>From memory you MUST use American date formatting with Access (e.g.
04/23/2001) but it will probably be better to use a parameter anyway,
allowing the TDataset to set the value correctly.
HTH
Xander
----- Original Message -----
From: "Alan Rose" <[EMAIL PROTECTED]>
To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]>
Sent: Monday, April 23, 2001 9:43 AM
Subject: [DUG]: Access DateTime
> Hi, I have been using the following syntax to update a datetime field in a
> Access 2000 table
>
> Update tablename set field = #23-APR-2001#
>
> I'd now like to add a timestamp as well, but have had no luck in figuring
> out the syntax. e.g.
> Update tablename set field = #23-APR-2001 02:23:00 PM#
>
> Can someone tell me what format I should be using
>
> --------------------------------------------------------------------------
-
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
> To UnSub, send email to: [EMAIL PROTECTED]
> with body of "unsubscribe delphi"
>
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
