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>


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 Montoya
Received on Fri Jan 08 1993 - 18:33:52 CET

Original text of this message