Re: Date Formatting for dd/mm/yyyy

From: Klint Gore <kgore4(at)une(dot)edu(dot)au>
To: J Ottery <jottery(at)becsystems(dot)com(dot)au>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Date Formatting for dd/mm/yyyy
Date: 2008-07-03 05:42:14
Message-ID: 486C66B6.9040100@une.edu.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)une(dot)edu(dot)au

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dave Coventry 2008-07-03 06:42:56 Re: SAST FATAL: could not access private key file "server.key"
Previous Message Matt Magoffin 2008-07-03 05:28:37 Re: Memory use in 8.3 plpgsql with heavy use of xpath()