Buzz Hill wrote:
> I am trying to pull records from a Microsoft Access db using
> ODBC.
..
> The problem I am having is with
> dates. Something as simple as:
>
> SELECT * FROM CostingHeader
> where DeliveryDate = '2/6/2004'
Access has its own unique syntax for dates (surrounded with # and
in mm/dd/yyyy format, I think). However, I have a feeling it will accept
Ansi standard date format in a quoted string ('2004-02-06' for a date or
'2004-02-06T12:02:02' for s date with time (the T is important).
--
Nikki Locke, Trumphurst Ltd. PC & Unix consultancy & programming
http://www.trumphurst.com/
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
