Hi everybody,
How can subtract or plus a one year with date
For example
plus
getdate + 1 year
2013-10-04 + 1 year = 2014-10-04
substract
getdate + 1 year
2013-10-04 - 1 year = 2012-10-04
Please advices.
Regards!
plus or subtract date
Moderator: NorbertKrupa
Re: plus or substract date
Hi!
Code: Select all
daniel=> \set dt 'DATE(20131004::VARCHAR)'
daniel=> select :dt;
DATE
------------
2013-10-04
(1 row)
Code: Select all
daniel=> select :dt - INTERVAL '1 YEAR' ;
?column?
---------------------
2012-10-04 00:00:00
(1 row)
daniel=> select :dt - 1::INTERVAL YEAR;
?column?
---------------------
2012-10-04 00:00:00
(1 row)
daniel=> select :dt - INTERVAL '1Y' ;
?column?
---------------------
2012-10-04 00:00:00
(1 row)
daniel=> select :dt - INTERVAL '1YEAR' ;
?column?
---------------------
2012-10-04 00:00:00
(1 row)
-
- Newbie
- Posts: 5
- Joined: Tue Sep 24, 2013 4:01 pm
Re: plus or substract date
Hi,
Thank you so much !
Best Regards!
Thank you so much !
Best Regards!
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: plus or substract date
FYI...
We can also use the ADD_MONTHS function...
We can also use the ADD_MONTHS function...
Code: Select all
dbadmin=> \set dt 'DATE(20131004::VARCHAR)'
dbadmin=> select :dt, add_months(:dt, 12) plus_1_year, add_months(:dt, -12) minus_1_year;
DATE | plus_1_year | minus_1_year
------------+-------------+--------------
2013-10-04 | 2014-10-04 | 2012-10-04
(1 row)
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.