Home » RDBMS Server » Server Administration » update date by adding 3 more months
update date by adding 3 more months [message #373285] Mon, 09 April 2001 22:36 Go to next message
xw
Messages: 1
Registered: April 2001
Junior Member
Hi,

anybody know in sql how to write the query for:

if i want to update the date by add 3 more months to the old date in another table.

example now, need to update the new_date in table a by plus another 3 months to old_date from table b

how ?

thank you very much!
Re: update date by adding 3 more months [message #373286 is a reply to message #373285] Mon, 09 April 2001 23:52 Go to previous message
Naresh Sharma
Messages: 12
Registered: April 2001
Junior Member
You can use add_months function to do this.

select add_months(sysdate,3) from dual;

Will give you a date which is 3 months after.

--------------------
HTH

Naresh
Previous Topic: hi
Next Topic: Inssert into View
Goto Forum:
  


Current Time: Mon Dec 23 09:48:55 CST 2024