Re: PL/SQL

From: Marcin Buchwald <Marcin.Buchwald_at_agora.pl>
Date: Mon, 21 Jan 2002 10:13:40 +0100
Message-ID: <3C4BDBC4.10A7B904@agora.pl>

try this one

  CURSOR c1 IS
  SELECT *
  FROM xyz
  WHERE datetime between
to_date(to_char(sysdate,'dd/mm/rrrr'),'dd/mm/rrrr')+6/24 and to_date(to_char(sysdate,'dd/mm/rrrr'),'dd/mm/rrrr')+9/24;

WK Yeoh wrote:

> 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 - 03:13:40 CST