On 04/03/2007 18:56, Garry Saddington wrote:
# select now();
now
-------------------------------
2007-03-04 18:07:54.626267+01
(1 row)
Which is precisely what I expect.
Which is precisely what I get, but I want 04-03-2007.
Ahh! Then you need to use to_char(). The datestyle setting in
postgresql.conf differentiates *only* between European and American date
formats - i.e. the relative order of day and month. It doesn't set the
exact output format.
Ray.
---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---------------------------------------------------------------
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
