PL/SQL

Hi,

I have a PL/SQL statement like below:

  CURSOR c1 IS
  SELECT *
  FROM xyz
  WHERE datetime between to_date('20-01-02:06:00:00','dd-mm-rr hh24:mi:ss')   and to_date('20-01-02:09:00:00','dd-mm-rr hh24:mi:ss');

Is there any way I can substitute the date '20-01-02' portion with everyday's date instead of hard code it. The time of '06:00:00' is fixed.

Pls help,
Wk Received on Mon Jan 21 2002 - 00:42:13 CST