Date Formatting for dd/mm/yyyy - Mailing list pgsql-general

From J Ottery
Subject Date Formatting for dd/mm/yyyy
Date
Msg-id 5660703d-6b25-47fd-a1ec-9e635d109af8@z16g2000prn.googlegroups.com
Whole thread Raw
Responses Re: Date Formatting for dd/mm/yyyy
Re: Date Formatting for dd/mm/yyyy
List pgsql-general
Hi all.
I am using Postgres 8.3 with Windows XP Pro.
System date format is dd/MM/yyyy

Having problems when I writing records to a database with a single
'date' type field.

e.g.  FieldByName('Date').ASString:='2/2/2003'

When the row is viewed in pgAdmin it is always 1899-12-30

I have tried changing the datestyle in postgresql.conf thus:

datestyle='iso,dmy'
datestyle='dmy'
datestyle='ymd'
datestyle='European'

also

lc_time= 'English_Australia.1252'

(obviously stopping and starting Server)


Nothing seems to make any difference.
Who has got an answer to this.

Also thanks to Craig Ringer and others for answering my earlier
questions, it greatly helped me get up and running with postgres.





pgsql-general by date:

Previous
From: "Brian A. Seklecki (Mobile)"
Date:
Subject: Re: LDAP Authentication
Next
From: Tom Lane
Date:
Subject: Re: Memory use in 8.3 plpgsql with heavy use of xpath()