Re: SQL statements

On Tue, 26 Jun 2007 10:02:24 -0700, colmkav <colmjkav_at_yahoo.co.uk> wrote:

>
>Can anyone explain why when I run the first statement in Oracle XE I
>get lots of records where sourceid = 3 and the riskdate is 18-JUN-07,
>however when I run the 2nd statement I get the result 0 returned?
>Surely I should get no records with a date of 18-jun-07 if the second
>statement returns 0?
>
>
>select * from ta_sma where sourceid = 3 order by riskdate desc
>
>select * from ta_sma where sourceid = 3 and riskdate = '18-jun-07'

If riskdate is a date, it can potentially also store a time. However Oracle always supplements those parts of a date literal you don't specify from the sysdate.

-- 
Sybrand Bakker
Senior Oracle DBA