Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: apply rtrim on DATE data

Re: apply rtrim on DATE data

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Mon, 5 Nov 2007 17:52:46 +0100
Message-ID: <472f4a79$0$235$e4fe514c@news.xs4all.nl>

"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US