Thanks Neven. This statement works
update tablename set datetimefield = Format("24/04/2001 2:02 PM","dd/mm/yyyy
hh:nn")
:)
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Neven MacEwan
Sent: Monday, April 23, 2001 11:06 AM
To: Multiple recipients of list delphi
Subject: Re: [DUG]: Access DateTime
Alan
Does Access 2000 support the CAST or CONVERT function
reason - I noticed the other day that the MS SQL Query builder uses CAST to
select/update datetimes, there is the vain hope that M$ are attempting to be
consistent
HTH
Neven
----- Original Message -----
From: Alan Rose <[EMAIL PROTECTED]>
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
Sent: Monday, 23 April 2001 10:15
Subject: RE: [DUG]: Access DateTime
> 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"
>
---------------------------------------------------------------------------
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"
