You can use the next_day function: http://download.oracle.com/docs/cd/E11882_01/server.112/e10592/functions104.htm#SQLRF00672 Should by something like: to_char(next_day(sysdate,'MONDAY'),'MMDDYYYY') and to_char(next_day(sysdate+7,'MONDAY'),'MMDDYYYY') Harel Safra On 07/01/2010 06:44, Roger Xu wrote:
Hi list, How do I get the next two mondays in MMDDYYYY format?For instance, if we run the sql today, we want the output to be 01112010 and 01182010.Thanks, Roger Xu
-- //www.freelists.org/webpage/oracle-l