MARK, Dont ever try to format dates in SQL.
Always use a parameterized Query e.g.
Select * from Tbl where ColumnDate <+ :SomeDate. Do this consistently and
you will not have any problems regardless of Database (Except for perhaps
the odd problem with Certain versions of ODBC for SQL Server but then what
do you expect from MS)
-----Original Message-----
From: Mark Derricutt <[EMAIL PROTECTED]>
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
Date: Thursday, 8 July 1999 11:21
Subject: Re: [DUG]: SQL Dates/Times
--On Thursday, July 08, 1999, 11:11 AM +1200 Mark Derricutt
<[EMAIL PROTECTED]> wrote:
> Whats the correct formatting for a date/time combination in SQL?
"1-Jan-1998 12:30:00 AM" works :-) w00p.
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
