Set Datestyle - Mailing list pgsql-sql

From Tubagus Nizomi
Subject Set Datestyle
Date
Msg-id 01052109565701.01337@ocemz
Whole thread Raw
Responses Re: Set Datestyle
List 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


pgsql-sql by date:

Previous
From: Alexander Dederer
Date:
Subject: Re: timestamp bug
Next
From: speeves
Date:
Subject: convert date to time?