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

date format?

P: n/a
Hi,

how do I figure out, what internal date format is used by
PostgreSQL (7.1.3)? Or how do I set it to the desired format
after I've already created the table?
I don't know what's standing in my db?
08.04.2003 | 04.08.2003??
April | August

thanks

Andi
Nov 11 '05 #1
Share this Question
Share on Google+
2 Replies

P: n/a
select * from pg_settings;
and find the DateStyle setting. Mine is 'ISO with US (NonEuropean)
conventions' (mm/dd/yyyy).
European is dd/mm/yyy

Ron

Andreas Buer wrote:
Hi,

how do I figure out, what internal date format is used by
PostgreSQL (7.1.3)? Or how do I set it to the desired format
after I've already created the table?
I don't know what's standing in my db?
08.04.2003 | 04.08.2003??
April | August

thanks

Andi


Nov 11 '05 #2

P: n/a
bu**@gmx.net (Andreas Buer) wrote in message news:<ea**************************@posting.google. com>...
Hi,

how do I figure out, what internal date format is used by
PostgreSQL (7.1.3)? Or how do I set it to the desired format
after I've already created the table?
I don't know what's standing in my db?
08.04.2003 | 04.08.2003??
April | August

thanks

Andi


http://techdocs.postgresql.org/techd...sintervals.php
Nov 11 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.