there's a slight rounding error with "select sysdate-0.33/24 from dual;"

alter session set nls_date_format='mm/dd/yy hh24:mi:ss';
select sysdate, sysdate-0.33/24 , sysdate - (20/1440) from dual;

SYSDATE SYSDATE-0.33/24 SYSDATE-(20/1440)
----------------- ----------------- -----------------
08/30/02 11:03:24 08/30/02 10:43:36 08/30/02 10:43:24




Hervén Stefan <stefan.[Email Address Removed] wrote:

>
>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 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
>
>


--
Sr. DBA


__________________________________________________________________
The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp

Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/
Oracle LazyDBA home page