Set Datestyle

From: Tubagus Nizomi <nizomi(at)dnet(dot)net(dot)id>
To: pgsql-sql(at)postgresql(dot)org
Subject: Set Datestyle
Date: 2001-05-21 02:56:57
Message-ID: 01052109565701.01337@ocemz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Grant 2001-05-21 05:26:38 Re: [SQL] problem while starting server ???
Previous Message Hans-Jürgen Schönig 2001-05-20 19:42:37 Transposing data