pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Changing Default date format
2+ messages / 2 participants
[nested] [flat]

* Changing Default date format
@ 2000-07-27 08:35  George P. Esperanza <george@calamba.laguna.net>
  0 siblings, 1 reply; 2+ messages in thread

From: George P. Esperanza @ 2000-07-27 08:35 UTC (permalink / raw)
  To: pgsql-interfaces



Hello!

How do i change the default (ISO) date/time format to (Postgres) format?
I need to 'SET DATESTYLE TO Postgres' for every session, is there a way
to set this permanently?

I'm using postgres 7.0.2 over linux.

George Esperanza




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

* Re: Changing Default date format
@ 2000-07-28 02:48  Thomas Lockhart <lockhart@alumni.caltech.edu>
  parent: George P. Esperanza <george@calamba.laguna.net>
  0 siblings, 0 replies; 2+ messages in thread

From: Thomas Lockhart @ 2000-07-28 02:48 UTC (permalink / raw)
  To: George P. Esperanza <george@calamba.laguna.net>; +Cc: pgsql-interfaces

> How do i change the default (ISO) date/time format to (Postgres) format?
> I need to 'SET DATESTYLE TO Postgres' for every session, is there a way
> to set this permanently?

http://postgresql.org/docs/postgres/x1137.htm sez:

There are several ways to affect the appearance of date/time types: 

 The PGDATESTYLE environment variable used by the backend
 directly on postmaster startup. 

 The PGDATESTYLE environment variable used by the frontend
 libpq on session startup. 

 SET DATESTYLE SQL command. 


These should be sufficient. You can also adjust a #define in a header
file and rebuild Postgres. Look for something with "DATESTYLE" in the
include directories.

                     - Thomas



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

end of thread, other threads:[~2000-07-28 02:48 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-07-27 08:35 Changing Default date format George P. Esperanza <george@calamba.laguna.net>
2000-07-28 02:48 ` Thomas Lockhart <lockhart@alumni.caltech.edu>

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