Try the TRUNC() function in your Oracle query. You can pass date/time format as the 2nd parameter, but leaving that out seems to default to getting just the date portion. E.g.:

SELECT TRUNC(myDateTimeColumn) AS MyDateColumn
...

>Hi there I am using Oracle as the back end. But date type in Oracle stores time whether you want it or not. I need to just have the date portion coming back from Oracle in a SQL statement for comparison with a date value.
>
>Any ideas?
>
>Jason