7/5/2023 0 Comments Sql server datediff![]() ![]() ![]() Let’s look at some examples of the SQL Server function DATEDIFF to understand how to use the DATEDIFF function in SQL Server (Transact-SQL). SQL Server vNext, SQL Server 2016, SQL Server 2015, SQL Server 2014, SQL Server 2012, SQL Server 2008 R2, SQL Server 2008, SQL Server 2005 The DATEDIFF function can be used in future versions of SQL Server (Transact-SQL): This could be one of the following values: Meaning (any of)ĭate1, date2 – two dates to calculate the difference between them. Interval – time interval for calculating the difference between date1 and date2. Syntax of the DATEDIFF function in SQL Server (Transact-SQL)ĭATEDIFF( interval, date1, date2 ) Parameters or arguments
0 Comments
Leave a Reply. |