Condor, 10.04.2013 15:03:
> 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 ?
A date column does NOT have a format.
The format is only applied by the client application when _displaying_ the date.
Btw. 2009-02-18 is not the US format, it's the ISO format, in the US the format 02/18/2012 is used.
psql (one of the possible client applications) uses the "datestyle" parameter to decide on how to format a date column
whendisplaying it.
If you change the "datestyle" parameter in postgresql.conf, it will influence the way psql displays the date values.
ProbablypgAdmin will also check that setting (as I don't use pgAdmin I can't really tell).
Thomas
