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"
