In dates, a single day = 1. Thus
sysdate + 1 = same time tomorrow sysdate + 7 = same time next week sysdate + 1/24 = one hour from now sysdate + 1/24/60 = one minute from now sysdate + 1/24/60/60 = one second from now etc etc You can also use trunc and round hth connor --- shuan.tay\(PCI¾G¸R³Ô\) <[EMAIL PROTECTED]> wrote: > Hi Gurus, > > i know there's 'add_month', > is there any built-in function like 'add_hour' or > 'add_minute'? > or i have to write a function to add it? > > thanks in advance. > > ===== Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "Remember amateurs built the ark - Professionals built the Titanic" __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).