Re: Adding dates in ORACLE?

From: Michael Tharp <mtharp_at_minn.net>
Date: 1995/11/04
Message-ID: <47g987$ia4_at_bronto.minn.net>#1/1


Assuming the date in the table is of a DATE data type, you should be able to get your new date 1 week later by a simple

     Select DATE_COLUMN + 7 from TABLE_NAME ;

If the date is a CHAR or VARCHAR data type, your would need

     Select To_Date(DATE_COLUMN) + 7 from TABLE_NAME ;

Check the SQL*Plus ADD_MONTHS() , LAST_DAY() , TO_DATE() & TO_CHAR() functions.

-- 

Michael Tharp

St. Paul, Minnesota USA
mtharp_at_minn.net
Received on Sat Nov 04 1995 - 00:00:00 CET

Original text of this message