Ansi, bless their cotton socks, require US date format 'mm/dd/yyyy' - since
they are the centre of the universe - non! Unless MS have usurped that
position for ODBC.
Max
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Tony Sinclair
Sent: Wednesday, 27 October 1999 17:10
To: Multiple recipients of list delphi
Subject: [DUG]: Database Explorer Date Literals
Hi all,
I am using database explorer to test an ODBC connection for different
types of SQL and I am unable to get it to accept date literals in the
WHERE clause. I am unsure as to whether I am using the correct
delimiter and if so, does it depend on the SQL definition in the ODBC
driver? e.g. the differences in Microsoft SQL and just about everyone
elses SQL :-)
If I use single quotes around various different types of date literal
e.g. '16/09/99' or '16-09-99' etc I get a Invalid date, time or
timestamp error (BDE Error 13059). If I use double quotes I get Invalid
Column Name (BDE Error 9729). Suggestions anyone
thanks in advance
Tony Sinclair
Holliday Group Limited
Christchurch
New Zealand
---------------------------------------------------------------------------
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
