No luck. My only solution to date has been to use a parametised dataset. But
i'd really like to do this by building up a sql string. I've been searching
Microsofts website and all their examples have been in a simple date format
like #1/1/1999# with no time stamp.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Neven MacEwan
Sent: Monday, April 23, 2001 10:03 AM
To: Multiple recipients of list delphi
Subject: Re: [DUG]: Access DateTime
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"
---------------------------------------------------------------------------
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"
