pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Set Datestyle
2+ messages / 2 participants
[nested] [flat]

* Set Datestyle
@ 2001-05-21 02:56  Tubagus Nizomi <nizomi@dnet.net.id>
  0 siblings, 1 reply; 2+ messages in thread

From: Tubagus Nizomi @ 2001-05-21 02:56 UTC (permalink / raw)
  To: 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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Set Datestyle
@ 2001-05-22 15:36  Peter Eisentraut <peter_e@gmx.net>
  parent: Tubagus Nizomi <nizomi@dnet.net.id>
  0 siblings, 0 replies; 2+ messages in thread

From: Peter Eisentraut @ 2001-05-22 15:36 UTC (permalink / raw)
  To: Tubagus Nizomi <nizomi@dnet.net.id>; +Cc: pgsql-sql

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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2001-05-22 15:36 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-05-21 02:56 Set Datestyle Tubagus Nizomi <nizomi@dnet.net.id>
2001-05-22 15:36 ` Peter Eisentraut <peter_e@gmx.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox