On Sunday 04 March 2007 15:28, Raymond O'Donnell wrote: > On 04/03/2007 12:58, Jorge Godoy wrote: > > Garry Saddington <garry@xxxxxxxxxxxxxxxxxxxx> writes: > >> I have 'datestyle ISO,DMY' set in postgresql.conf but the date output is > >> still rendered in the format (y,m,d) . How can I change this behaviour? > > > > ISO means y-m-d... > > The default postgresql.conf that is installed has > > datestyle = iso,mdy > > though commented out - on a new installation I uncomment this line as a > matter of course and change it to "iso,dmy" and it works fine. > > Are you sure that PostgreSQL is presenting the dates in the wrong > format? Could there be another layer that's swapping the month and year > around? - try SELECTing some date values from psql and see what you get. > I tried pgAdmin3 on windows to run 'select now()' and it still does not return the correct datestyle. Regards Garry
