Oops, right. FWIW, I misunderstood Jason's last 4 words -- "with a date value." No way to get the date data type, which I think you are right to assume he means, directly via SPT AFAIK. Of course, any of the functions we've mentioned lops the time portion off of the datetime value, yielding "just the date" even though it is still the datetime data type. In some cases, such as wanting to do date-only comparisons or subselects, that still can be useful I guess.
>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only