Alan
What about
Update tablename set field = '2001-04-23 14:23:00'
----- Original Message -----
From: Alan Rose <[EMAIL PROTECTED]>
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
Sent: Monday, 23 April 2001 09:43
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"
