Alvaro Herrera wrote:
Russell Smith wrote:The issue is output, not input. SET datestyle='dmy'; SELECT '03-03-2004'::date Will return '2007-03-03', not 03-03-2004 as is the set datestyle.You are aware that DateStyle controls both input and output, _separately_, yes?
No, I've RTFM'd to fix that.
Thanks
Russell
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
