Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Problem comparing dates (SQLPLUS)

Re: Problem comparing dates (SQLPLUS)

From: Peter L <news_at_abc.freeserve.co.uk>
Date: Fri, 24 Dec 1999 21:20:31 -0000
Message-ID: <840r14$llt$1@news5.svr.pol.co.uk> 





Sam Jordan wrote in message <38633FAE.82771B50_at_spin.ch>...


>


>I would like to list all entries where the month of the column


>'finishdate' is


>less than the month of 'sysdate', but the statement returns also entries


>where those months are equal. Why does this happen?


>




Does last_day leave the time element of the date intact.  If your first date
had the time stripped off when written to the database that would explain
the results.


Received on Fri Dec 24 1999 - 15:20:31 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US