sql add year statement
I have sysdate
in one co开发者_如何学JAVAlumn and I want to add two years in another. I would not like to use sysdate + 365
Is there any other way?
select add_months(sysdate, 12) from dual
SELECT your_date_column + interval '2' year FROM dual
精彩评论