You can set it either within the session, or set a default. For details,
check this page in the docs:
http://www.postgresql.org/idocs/index.php?sql-set.html
(Look for DATESTYLE)
Regards,
-Nick
--------------------------------------------------------------------------
Nick Fankhauser nickf@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788
Ray Ontko & Co. Software Consulting Services http://www.ontko.com/
-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Bronx
Sent: Saturday, June 29, 2002 6:13 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Change date format
Hi,
does anybody know who I can change a default format date displayed in table.
Date is displayed in 'Y-m-d' format but it should be 'd-m-Y'.
How can I change it?
Thanks
