this will give you the first of the month for a given date inner select select DATEDIFF(MONTH, 0, GETDATE()) will give the number of months from 1900-01-01 here it is 1350 this will be add to …

SELECT FieldOne, DateField FROM Table WHERE (DateField> DATEADD(day, @days, GETDATE())) Where @days = -10 Any ideas into what I am doing wrong? Incidentally I am …

I am trying to add hours to current time like -- NOT A VALID STATEMENT -- SELECT GetDate(DATEADD (Day, 5, GETDATE())) How can I get hours ahead time in SQL Server?

Select dateadd(S, [unixtime], '1970-01-01') From [Table] In case anyone wonders why 1970-01-01, This is called Epoch time. Below is a quote from Wikipedia: The number of seconds that …

I used GETDATE () as a date to work with, you can replace it with the date which you need. Here's how this works: First we format the date in YYYYMMDD... format truncating to keep …

This works by taking the number of months that have passed since the initial date in SQL's date system (1/1/1990), then adding that number of months to the date "-1" (12/31/1899) using the …

How can I add one month to a date that I am checking under the where clause? select * from Reference where reference_dt + 1 month

Column_Name BETWEEN @StartDate AND @EndDate. This is because the @EndDate = 00:00:00.000 for the time, which doesn't pick up all the values for that day. How would I …

According to MSDN, in DATEADD (datepart , number , date ) number is an expression that can be resolved to an int that is added to a datepart of date. User-defined variables are valid. If you …

How to add minutes(INT) to the time part of datetime ? For example : If I have datetime variable like this :