Date Compare

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