AFAIK, you can not do this without using either a CursorAdapter or a remote view which defines the field data type as Date instead of DateTime. TRUNC() won't work and neither will:

to_date(to_char(column_name, 'MM/DD/YYYY'), 'MM/DD/YYYY')

Other than a CA or RV, the best you can do is accept what the resulting cursor brings back, then do a secondary query on the return cursor where you can TTOD() the datetime field.

>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