On 04/10/2013 06:03 AM, Condor wrote:
Hello ppl,
I have a database where the previous owner use US date format in date
fields:
2009-02-18
Is there a way how to convert the fields in European format 18-02-2009.
I mean existing date in records. What's will be happened if I change format
in postgresql.conf ?
The dates are stored as a non formatted value. What you are seeing is
the output formatting:
http://www.postgresql.org/docs/9.2/interactive/datatype-datetime.html#DATATYPE-DATETIME-OUTPUT
In other words the data in the fields will not be converted.
If you want a European style formatting then you can set the
DateStyle='SQL,DMY':
test=> set datestyle='SQL,DMY';
SET
test=> SELECT now()::date;
now
------------
10/04/2013
(1 row)
This can be done as needed or by setting it in postgresql.conf
Cheers,
Hristo S.
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
