470,581 Members | 2,438 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,581 developers. It's quick & easy.

date format?

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
2 3403
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
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.

Similar topics

15 posts views Thread by Simon Brooke | last post: by
4 posts views Thread by Richard Hollenbeck | last post: by
5 posts views Thread by Macca | last post: by
12 posts views Thread by Assimalyst | last post: by
20 posts views Thread by andreas | last post: by
30 posts views Thread by fniles | last post: by
1 post views Thread by livre | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.