Re: Date problem
Started by Ricardo Ryoiti S. Juniorabout 23 years ago2 messagesgeneral
Ola,
On Mon, 27 Jan 2003, Marcelo Pereira wrote:
How can I make PostgreSQL to use dates as DD/MM/YYYY ????
I use "SET DATESTYLE TO SQL,EUROPEAN" as soon as the connection is
made.
[] s
Ricarod.
Import Notes
Reply to msg id not found: Pine.LNX.4.20.0301271456020.15142-100000@ni.hmmg.sp.gov.br
"Ricardo Ryoiti S. Junior" <suga@netbsd.com.br> writes:
On Mon, 27 Jan 2003, Marcelo Pereira wrote:
How can I make PostgreSQL to use dates as DD/MM/YYYY ????
I use "SET DATESTYLE TO SQL,EUROPEAN" as soon as the connection is
made.
In 7.3 you can set that as the default datestyle in postgresql.conf.
There are klugier ways of making it the default in prior releases
(PGDATESTYLE env. variable or -e postmaster switch, if memory serves).
regards, tom lane