Try,
convert (datetime, convert (varchar(50), DateTimeAdded, 102))
convert (varchar(50), DateTimeAdded, 102) converts DateTimeAdded to a string
formatted as ANSI date (without time), and convert (datetime, ) converts it
back to DATETIME.
Dennis.
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Derricutt, Mark
> Sent: Wednesday, 8 March 2000 10:29
> To: Multiple recipients of list database
> Subject: RE: [DUG-DB]: Dates in SQL7
>
>
> > What is the date type of DateTimeAdded? There is a CONVERT
>
> It's a DATETIME field, I just tried convert but no matter
> what I put in for
> the style param it didn't change the output at all.
> --------------------------------------------------------------
> -------------
> New Zealand Delphi Users group - Database List -
> [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
