By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,710 Members | 1,960 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,710 IT Pros & Developers. It's quick & easy.

Is it not datestyle that determines date format output?

P: n/a
The way PostgreSQL deals with the date format is confusing me...
I need PostgreSQL to return dates from selects at this format: "dd/mm/yyyy",
but it insists in returning it as "yyyy-mm-dd". I say "insists" cause I had
already set datestyle to "European" (in postgresql.conf) which represents
the format I want... I checked it executing: "SHOW DATESTYLE" and I got:
DateStyle
-----------
ISO with European conventions

When inserting dates, PostgreSQL understands very well my date format like
"dd/mm/yyyy", but it is also important to get the date like that.
I think it's possible, but I had tried all the tricks I knew or I could
retrieve from manual...

Any ideas?
Thank you all.
Netto

Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Check the datestyle settings in the manual. Also look at to_char, with that
you can format the data any way you like,

Maybe: set DateStyle = sql,european;

On Thu, Dec 11, 2003 at 03:35:39PM -0200, Netto wrote:
The way PostgreSQL deals with the date format is confusing me...
I need PostgreSQL to return dates from selects at this format: "dd/mm/yyyy",
but it insists in returning it as "yyyy-mm-dd". I say "insists" cause I had
already set datestyle to "European" (in postgresql.conf) which represents
the format I want... I checked it executing: "SHOW DATESTYLE" and I got:
DateStyle
-----------
ISO with European conventions

When inserting dates, PostgreSQL understands very well my date format like
"dd/mm/yyyy", but it is also important to get the date like that.
I think it's possible, but I had tried all the tricks I knew or I could
retrieve from manual...

Any ideas?
Thank you all.
Netto




---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
--
Martijn van Oosterhout <kl*****@svana.org> http://svana.org/kleptog/ (... have gone from d-i being barely usable even by its developers
anywhere, to being about 20% done. Sweet. And the last 80% usually takes
20% of the time, too, right?) -- Anthony Towns, debian-devel-announce


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE/3ij3Y5Twig3Ge+YRAhw1AJ9As1IVgBioKHy2N2uOY1PMlwNlqw Cg1iJo
CjBcWBNo1uwN/IdSTpqPk7Q=
=iu2n
-----END PGP SIGNATURE-----

Nov 12 '05 #2

P: n/a
On Thu, 11 Dec 2003, Netto wrote:
The way PostgreSQL deals with the date format is confusing me...
I need PostgreSQL to return dates from selects at this format: "dd/mm/yyyy",
but it insists in returning it as "yyyy-mm-dd". I say "insists" cause I had
already set datestyle to "European" (in postgresql.conf) which represents
the format I want... I checked it executing: "SHOW DATESTYLE" and I got:
DateStyle
-----------
ISO with European conventions

When inserting dates, PostgreSQL understands very well my date format like
"dd/mm/yyyy", but it is also important to get the date like that.
I think it's possible, but I had tried all the tricks I knew or I could
retrieve from manual...


This may be a dup (it arrived in my inbox on 11 Dec 2003), but I'll reply
just in case.

What flavor of Postgresql are you running? I'll assume 7.4.

I'm assuming you've read this section of the docs:

http://www.postgresql.org/docs/curre...-datetime.html

Have you tried entering:

set DateStyle='SQL, dmy';

ISO style makes it the yyyy-mm-dd format, SQL makes it the other.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 12 '05 #3

P: n/a
""scott.marlowe"" <sc***********@ihs.com> escreveu na mensagem
news:Pi*************************************@css12 0.ihs.com...
This may be a dup (it arrived in my inbox on 11 Dec 2003), but I'll reply
just in case.
What flavor of Postgresql are you running? I'll assume 7.4.
I'm assuming you've read this section of the docs:
http://www.postgresql.org/docs/curre...-datetime.html
Have you tried entering:
set DateStyle='SQL, dmy';
ISO style makes it the yyyy-mm-dd format, SQL makes it the other.


Hey Scott,... thank you for the tips,... I forgot mentioning the PostgreSQL
version I'm using... its 7.3.2. I read the documentation section you
suggested, and it really solves my problem, since I upgrade postgresql to
7.4.

Netto
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.