Date Formatting for dd/mm/yyyy

From: J Ottery <jottery(at)becsystems(dot)com(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: Date Formatting for dd/mm/yyyy
Date: 2008-07-03 02:43:42
Message-ID: 5660703d-6b25-47fd-a1ec-9e635d109af8@z16g2000prn.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brian A. Seklecki (Mobile) 2008-07-03 02:50:35 Re: LDAP Authentication
Previous Message Douglas McNaught 2008-07-03 02:32:09 Re: Confusion about ident sameuser