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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement