Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql General > Date Formatting...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 3 Topic 15954 of 16301
Post > Topic >>

Date Formatting for dd/mm/yyyy

by J Ottery <jottery@[EMAIL PROTECTED] > Jul 2, 2008 at 07:43 PM

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.
 




 3 Posts in Topic:
Date Formatting for dd/mm/yyyy
J Ottery <jottery@[EMA  2008-07-02 19:43:42 
Re: Date Formatting for dd/mm/yyyy
kgore4@[EMAIL PROTECTED]   2008-07-03 15:42:14 
Re: Date Formatting for dd/mm/yyyy
artacus@[EMAIL PROTECTED]  2008-07-03 08:04:24 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Thu Aug 21 18:30:08 CDT 2008.