Dates In SQL
Posted on 2001-07-02
Using Ultradev I am querying an mdb to retrieve records based on date. I use a clause as below to do this:
WHERE DOB = #01/01/01#
Everything works OK and the records I expect are dsiplayed. However my problem starts when I try to connect to an Oracle DB using a DNS. Whenever I use the # characters I am told by an error message that I am using 'Invalid Characters'.
I know that the field I am trying to connect to is a Date/Time field and the same query works when implemented through a linked table query in Access...so why doesn't it work in Dreamweaver?
Thanks in advance.