Dates

From: Moore <rlmoore_at_purdue.edu>
Date: Thu, 24 Feb 2000 07:24:10 -0500
Message-ID: <Pine.SOL.4.10.10002240717530.14732-100000@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 - 06:24:10 CST