Happy new year to all! This will be my first post for this year. Recently, I was looking for a way to select rows in
a time interval. After looking, I found this blog with a lot of examples and then, I ran to execute them in sqlcmd. Here are my tests, I hope these are useful.
select current_timestamp go -- output 2012-01-02 00:51:22.660
Returns a specified date with the number interval (signed integer) added to a specified datepart of that date.
DATEADD(datepart, number, date)
Some dateparts are year (yy, yyyy), month (m,mm), day (d,dd), hour (hh), minute (mi,n), second (ss,s), millisecond (ms), etc.
SELECT DATEADD(YEAR, -1, CURRENT_TIMESTAMP) AS previous_year, DATEADD(YEAR,0,CURRENT_TIMESTAMP) AS present_year DATEADD(YEAR,1,CURRENT_TIMESTAMP) AS next_year GO -- output 2011-01-02 01:10:24.733 -- previous year 2012-01-02 01:10:24.733 -- present year 2013-01-02 01:10:24.733 -- next year