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
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.netReceived on Sat Nov 04 1995 - 00:00:00 CET