last_day vs '31-JAN-93'??
From: Devan F. Dewey <dewey_at_centerline.com>
Date: 8 Jan 1993 17:33:52 GMT
Message-ID: <dewey-080193124019_at_sebastian.centerline.com>
Date: 8 Jan 1993 17:33:52 GMT
Message-ID: <dewey-080193124019_at_sebastian.centerline.com>
If I wrote a query with a where clause:
where transdate between '01-JAN-93 and '31-JAN-93'
why would my results differ from:
where transdate between '01-JAN-93 and last_day(sysdate)
Any hints on how the last_day function returns the time component might be helpful.
-Devan
Devan F. Dewey | Senior Systems Analyst CenterLine Software | dewey_at_centerline.com 10 Fawcett Street | "Leme esplain - no dere is Cambridge, MA 02138 | too much. Leme sum up." -Inigo MontoyaReceived on Fri Jan 08 1993 - 18:33:52 CET