software

I have an ODBC connection to and Oracle db through MS Query. One of the
fields I'm trying to work on is a DateTime field and I'm having problems
selecting a particular date out of the field.
How can I look for quot;31/01/2006quot; when the info in the table is quot;2006-01-31
06:00:00quot;.
Note different slashes and different format as well as having the time.

Thanks in advance
Dean

Ok,
Now I have...
(to_char(VP_SCHEDULE.SHIFTSTARTDATE,'yyyy-mm-dd')='2006-01-31') and it
selects the correct data from the database but I want to be able to have the
user enter the date into a cell on the spreadsheet, usually i'd change the
date into [?] and then when run the query would ask for a parimeter. Here it
gives me an error saying that the quot;Literal does not match format stringquot; even
when I enter it exactly.

Any one got any ideas how I can round this?

Dean

quot;Deanquot; wrote:

gt; I have an ODBC connection to and Oracle db through MS Query. One of the
gt; fields I'm trying to work on is a DateTime field and I'm having problems
gt; selecting a particular date out of the field.
gt; How can I look for quot;31/01/2006quot; when the info in the table is quot;2006-01-31
gt; 06:00:00quot;.
gt; Note different slashes and different format as well as having the time.
gt;
gt; Thanks in advance
gt; Dean