I must be missing the obvious

#11

[...]

Quote:

I get today 30-JUN-04. If there are 10 records in X including 3 from
today, why does

'select count(1) from X where datestamp < '01-JUL-04' return 10 but

'select count(1) from X where datestamp <= '30-JUN-04' returns 7?

It's simple. Really your first query gets all the JUNE records. The
second query gets record with datestamp less than '01-JUN-04 00:00:00'
and records with datestamp equal to '01-JUN-2004 00:00:00' (not with
01-JUN-04 with some time portion). Again, '01-JUN-04 14:14:14' is
greater than '01-JUN-04'.

[...]

Be careful with DD-MON-YY. Use DD-MON-RR (or DD-MON-YYYY) instead.

[...]

Quote:

Don't use an implicit conversion of a string to a date! Use to_date()
instead. You have bug in your code just waiting to bite you.

Agreed. That's just a notation from replied message...

--
wbr,
Wit.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

I must be missing the obvious

comp.databases.oracle comp.databases.oracle

Re: I must be missing the obvious - 07-02-2004 , 09:13 AM