0 SQL Server 2012 New Date Functions

SQL Server 2008 introduced 4 new data types associated with the date and time, namely, the DATE, TIME, DATETIME2 and DATETIMEOFFSET data types.  The DATE data types stores only a date value while the TIME data type defines a time of a day without time zone awareness and is based on a 24-hour clock.  The DATETIME2 data type defines a date that is combined with a time of day that is based on a 24-hour clock and has a larger date range, a larger default fractional precision and an optional user-specified precision.  Lastly, the DATETIMEOFFSET data type defines a date that is combined with a time of day that has time zone awareness...

0 SQL Server DATEDIFF() Function

Definition and Usage The DATEDIFF() function returns the time between two dates. Syntax DATEDIFF(datepart,startdate,enddate) Where startdate and enddate are valid date expressions and datepart can be one of the following: datepartAbbreviation yearyy, yyyy quarterqq, q monthmm, m dayofyeardy, y daydd, d weekwk, ww weekdaydw, w hourhh minutemi, n secondss, s millisecondms microsecondmcs nanosecondns Example Now we want to get the number of days between two dates. We use the following SELECT statement: SELECT DATEDIFF(day,'2008-06-05','2008-08-05') AS DiffDate Result: DiffDate 61 Example Now we want to get the number of days...