Steps:
1.
show datestyle
DateStyle
ISO, DMY
2.
set datestyle to 'SQL, DMY';
show datestyle;
DateStyle
SQL, DMY
this should be the good result.
Now the tries:Edit the postgresql.conf. Set datestyle = 'SQL, DMY' parameter. Restart the DB server.
show datestyle
DateStyle
ISO, DMY
... there is no change.
the other try:
alter database test2 set datestyle to 'SQL, DMY';
SQL executed.
show datestyle
DateStyle
ISO, DMY
the same...
Am I missing something??? If I set
set datestyle to 'SQL, DMY' in a connection session then it works well for
that session.
I need this type of format:
auftragsdatum
27/06/2005
27/06/2005
27/06/2005
27/06/2005
27/06/2005
27/06/2005
21/11/2005
09/12/2005
07/07/2005
29/06/2005
I don't know what am I missing in the configuration.
I attach the postgres.conf.
Best regards,
Andy.
----- Original Message -----
From: "Tom Lane" <tgl@xxxxxxxxxxxxx>
To: "Andy" <frum@xxxxxxxxx> Cc: <pgsql-admin@xxxxxxxxxxxxxx> Sent: Monday, June 26, 2006 5:50 PM Subject: Re: [ADMIN] Problem Setting DateStyle
"Andy" <frum@xxxxxxxxx> writes:I tried to modify it in postgres.conf >>> datestyle = 'European' or datestyle = 'SQL, DMY' and I tried to make alter database test5 SET DateStyle='SQL, DMY';.... none of these worked.They work for me. Perhaps you should show us exactly what you did and what happened. regards, tom lane
Attachment:
postgresql.conf
Description: Binary data
