Re: [Q] DATE - 1/2 hour ????

From: nix <nix_at_gate.net>
Date: 1996/10/08
Message-ID: <325A5434.7D53_at_gate.net>#1/1


select *
  from emp
 where hiredate between sysdate-(1/48) and sysdate;

one added to a date means one day so just use that as the basis for any further date questions along these lines.

Keyoor wrote:
>
> Date : 08/10/1996
> Ref : news4.txt
>
> Hi folks !
>
> I want to subtract 1/2 an hour from any given date and find the records
> between these 2 dates.
>
> Can anybody give me the answer !
>
> Please send the answers to my e-mail also.
>
> Thanks in advance.
>
> Keyoor.
>
> --
> ---------------------------------------------------
> How HIGH You go depends on How DEEP Your Roots are.
> ---------------------------------------------------
> Keyoor Anant Brahme
 

-- 
robert
The statements and opinions expressed here
are my own and do not necessarily represent
those of my employer.
Received on Tue Oct 08 1996 - 00:00:00 CEST

Original text of this message