Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: apply rtrim on DATE data
"DA Morgan" <damorgan_at_psoug.org> schreef in bericht
news:1193949870.690784_at_bubbleator.drizzle.com...
> ouyang.jie_at_gmail.com wrote:
>> Hi All,
>> The sql below does not return anything,
>> select DTE_SYSDATE
>> from A_T_PR_TAXONOMY
>> WHERE DTE_SYSDATE = to_date( 20071031, 'yyyymmdd')
>>
>> snip
>>
>> DTE_SYSDATE is a DATE type field in the table A_T_PR_TAXONOMY. I am
>> confused at why the rtrim can make this difference.
>
> Things work better when done according to the docs:
>
> 1. Pass TO_DATE strings not integers: '20071031'
>
> 2. DTE_SYSDATE does not exist except perhaps in your database and we
> have no idea what it is.
DA:
Ad 2): Stop drinking and start reading:
***** DTE_SYSDATE is a DATE type field in the table A_T_PR_TAXONOMY. I am
***** confused at why the rtrim can make this difference.
Shakespeare Received on Mon Nov 05 2007 - 10:52:46 CST