Postgres Pro
Downloads
Home   >   mailing lists

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

From Klint Gore
Subject Re: Date Formatting for dd/mm/yyyy
Date
Msg-id 486C66B6.9040100@une.edu.au
Whole thread Raw
In response to Date Formatting for dd/mm/yyyy  (J Ottery <jottery@becsystems.com.au>)
List pgsql-general
Tree view 
J Ottery wrote:
> 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'
>
What is delphi's ShortDateFormat set to?

Does fieldbyname('Date').asdatetime := strtodate('2/2/2003') make any
difference?

klint.

--
Klint Gore
Database Manager
Sheep CRC
A.G.B.U.
University of New England
Armidale NSW 2350

Ph: 02 6773 3789
Fax: 02 6773 3266
EMail: kgore4@une.edu.au

pgsql-general by date:

Previous
From: "Matt Magoffin"
Date:
Subject: Re: Memory use in 8.3 plpgsql with heavy use of xpath()
Next
From: "Dave Coventry"
Date:
Subject: Re: SAST FATAL: could not access private key file "server.key"