Skip site navigation (1) Skip section navigation (2)

Re: Change date format

From: "Nick Fankhauser" <nickf(at)ontko(dot)com>
To: "Bronx" <tobronx(at)go2(dot)pl>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Change date format
Date: 2002-06-30 02:01:24
Message-ID: NEBBLAAHGLEEPCGOBHDGEENDFDAA.nickf@ontko.com (view raw or flat)
Thread:
Lists: pgsql-admin
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(at)ontko(dot)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(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org]On Behalf Of Bronx
Sent: Saturday, June 29, 2002 6:13 PM
To: pgsql-admin(at)postgresql(dot)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




In response to

pgsql-admin by date

Next:From: Dmitry MorozovskyDate: 2002-06-30 19:21:24
Subject: Re: TeDia2SQL 0.77 (Dia-->SQL DDL Tool) Released
Previous:From: BronxDate: 2002-06-29 23:12:51
Subject: Change date format

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group