Thread: Set Datestyle

Set Datestyle

From
Tubagus Nizomi
Date:
Hallo,

i have postgres 7.1 in Radhat 6.5
the Datestype default is ISO format

where is change default  Datestyle to Postgres format ??

i used Set Datestyle to postgres in plsql


test#>select now()         now
------------------------2001-05-21 09:55:36+07

test#>set datestyle to postgres;
SET VARIABLE 

test#>select now();             now
-------------------------------Mon May 21 09:56:19 2001 JAVT

but when i reconnect to plsql the datestype ISO again

Help me plz

Nizomi


Re: Set Datestyle

From
Peter Eisentraut
Date:
Tubagus Nizomi writes:

> where is change default  Datestyle to Postgres format ??

I think there's a PGDATESTYLE environment variable.  My recommendation is
that you use the default ISO format and use to_char to format you data for
output.

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter