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

Home -> Community -> Usenet -> c.d.o.tools -> Date Compare

Date Compare

From: <gmelo_at_bbr.cl>
Date: Wed, 14 Mar 2001 15:36:51 -0400
Message-ID: <MPG.1519a06a5ada5135989680@news.rdc.cl>

Hi:

There is a way to compare 2 dates, like this (for a cursor) :

Declare Cursor cur_date
Select PrimaryKey
From Table_Prod
Where InitiatDate&Hour <= sysdate And

      FinalDate&Hour >= sysdate;

????

I know the to_date and substr function, but doesn't work...

other way :
Where InitialDate&Hour - sysdate <= 0 And

      FinalDate&Hour - sysdate >=0

The answer isn't easy, many people is hang up with this...

Thanks Received on Wed Mar 14 2001 - 13:36:51 CST

Original text of this message

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