Re: Dates

From: XXX <XXXX_at_XXX.XXX>
Date: Thu, 24 Feb 2000 15:09:08 +0100
Message-ID: <893du5$1cj$1@scesie13.sie.siemens.at>

Sure, do you forgot the Y2K problems?
Try this :

SELECT FIELD1
FROM TABLE
WHERE ADATEFIELD >= TO_DATE('16-SEP-99', 'DD-MON-RR') Let me know how it happend, please.

vaclav.svara_at_anfdata.cz

Moore <rlmoore_at_purdue.edu> píse v diskusním pøíspìvku:Pine.SOL.4.10.10002240717530.14732-100000_at_herald.cc.purdue.edu...
> Greetings.
>
> I have been working with Oracle 7.3 after spending many months w/ SQL
> Server 6.5 and 7.0.
>
> May I say that date formats/functions etc in Oracle, well frankly, they
> suck.
>
> Any sure fire way to compare the value of a date field?
>
> I.E.
>
> The following
>
> SELECT FIELD1
> FROM TABLE
> WHERE ADATEFIELD >= TO_DATE('16-SEP-99', 'DD-MON-YY')
>
> will return different results then
>
> SELECT FIELD1
> FROM TABLE
> WHERE ADATEFIELD >= TO_DATE('16-SEP-1999', 'DD-MON-YYYY')
>
Received on Thu Feb 24 2000 - 08:09:08 CST