How can add 30 days in current date in SQL?

How can I add 5 days to current date in SQL?

SQL Server DATEADD() Function The DATEADD() function adds a time/date interval to a date and then returns the date.

How do you subtract 30 days from current date in SQL?

To subtract 30 days from current datetime, first we need to get the information about current date time, then use the now() method from MySQL. The now() gives the current date time. The method to be used for this is DATE_SUB() from MySQL. Here is the syntax to subtract 30 days from current datetime.

How do I write a current date in SQL query?

SQL Server GETDATE() Function The GETDATE() function returns the current database system date and time, in a 'YYYY-MM-DD hh:mm:ss. mmm' format.

How do I get last 90 days data in SQL?

4 Answers1Actually you can do GETDATE()-90 instead DATEADD(DAY, -90, GETDATE()) – huMpty duMpty. Feb 20, 2014 at 16:45.2@huMptyduMpty But 3 months is not necessarily 90 days, because months may have 30 or 31 days (or even 28 or 29 if we take February into account) – AlexB. May 2, 2017 at 12:22.SQL query for getting data for last 3 months - Stack Overflow