This content has been marked as final. Show 3 replies
pls try the following in when button pressed trigger
SELECT .... INTO.... FROM your_table WHERE your_date_field BETWEEN :DATEfld1 AND :DATEfld2 ;
Gul wrote:As'salamualikum Gul
In a 6i form cursor I need to select all the dates between two provided dates. I have two text fields FLD1 and FLd2 with date datatype. There is no table behind both the fields.
Now I have to select all the dates from 01-mar-2013 to '10-mar-2013'. how to do it?
Hope this helps
SELECT TO_DATE('01-MAR-2013', 'DD-MON-RRRR') - 1 + rownum AS d FROM ALL_OBJECTS WHERE TO_DATE('01-MAR-2013', 'DD-MON-RRRR') - 1 + rownum BETWEEN TO_DATE('01-MAR-2013', 'DD-MON-RRRR') AND TO_DATE('10-MAR-2013', 'DD-MON-RRRR')