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 [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bronx Sent: Saturday, June 29, 2002 6:13 PM To: [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html