sysdate - 20/60/24

is 20 minutes / 60 minutes in an hour / 24 hours in a day

-----Original Message-----
From: Louise Hebert [mailto:louise.[Email Address Removed] den 30 augusti 2002 15:50
To: LazyDBA.com Discussion
Subject: RE: DATE FUNCTIONS....


Hi,
to get sysdate - 20 minutes you can try:
select sysdate-0.33/24 from dual;

-----Message d'origine-----
De : Indrajit.[Email Address Removed] : 30 août, 2002 09:49
À : LazyDBA.com Discussion
Objet : DATE FUNCTIONS....


HI DBAs,
IF I WANT TO SELECT A DATE WHICH LIES BETWEEN (SYSDATE - 20 MINUTES) AND
SYSDATE...WHAT WILL BE THE QUERY FOR THE SAME?
HOW DO I GET SYSDATE - 20 MINUTES? IS THERE ANY FUNCTION IN ORACLE?
----------------------------------------------------------------------------

This message contains privileged and confidential information and is
intended only for the individual named. If you are not the intended
recepient you should not disseminate, distribute, store, print, copy or
deliver this message. Please notify the sender immediately by e-mail if you
have received this e-mail by mistake and immediately delete this e-mail from
your system.


E-mail transmission cannot be guaranteed to be secure or error-free as
information could be intercepted, corrupted, lost, destroyed, arrive late or
incomplete, or contain viruses. The sender therefore does not accept
liability for any errors or omissions in the contents of this message which
arise as a result of e-mail transmission. If verification is required
please request a hard-copy version.


--------------------------------------------------------------------------

--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page