When.com Web Search

Search results

1. Results From The WOW.Com Content Network

2. SQL Server DATEDIFF() Function - W3Schools

   www.w3schools.com/SQl/func_sqlserver_datediff.asp

   Definition and Usage. The DATEDIFF () function returns the difference between two dates, as an integer. Syntax. DATEDIFF (interval, date1, date2) Parameter Values. Technical Details. More Examples. Example. Return the difference between two date values, in months: SELECT DATEDIFF (month, '2017/08/25', '2011/08/25') AS DateDiff; Try it Yourself »

3. SQL DATEDIFF Function: Finding the Difference Between Two Dates

   www.sqltutorial.org/sql-date-functions/sql-datediff

   This tutorial shows you how to use the SQL DATEDIFF() function to calculate the difference between two dates.

4. DATEDIFF (Transact-SQL) - SQL Server | Microsoft Learn

   learn.microsoft.com/en-us/sql/t-sql/functions/datediff-transact-sql

   Transact-SQL reference for the DATEDIFF function. Returns the numerical difference between a start and end date based on datepart.

5. Difference of two date time in sql server - Stack Overflow

   stackoverflow.com/questions/2116540

   There are a number of ways to look at a date difference, and more when comparing date/times. Here's what I use to get the difference between two dates formatted as "HH:MM:SS": ElapsedTime AS. RIGHT('0' + CAST(DATEDIFF(S, StartDate, EndDate) / 3600 AS VARCHAR(2)), 2) + ':'.

6. DATEDIFF SQL Server Function

   www.mssqltips.com/sqlservertip/6491/datediff-sql-server-function

   DATEDIFF() is a basic SQL Server function that can be used to do date math. Specifically, it gets the difference between 2 dates with the results returned in date units specified as years, months days, minutes, seconds as an int (integer) value.

7. SQL Server DATEDIFF Function By Practical Examples

   www.sqlservertutorial.net/sql-server-date-functions/sql-server-datediff-function

   In this tutorial, you will learn how to use SQL Server DATEDIFF () function to calculate the number of years, months, weeks, days,etc., between two dates.

8. DATEDIFF - Datetime Difference in Seconds, Days, Weeks etc -...

   www.sqlines.com/sql-server/functions/datediff

   SQL Server DATEDIFF function returns the difference in seconds, minutes, hours, days, weeks, months, quarters and years between 2 datetime values. Quick Example: -- The difference is days between today and yesterday SELECT DATEDIFF (dd, GETDATE () - 1, GETDATE ()); -- Returns: 1 -- The number of seconds in 24 hours SELECT DATEDIFF (ss, GETDATE ...

9. DATEDIFF() SQL FUNCTION - DataCamp

   www.datacamp.com/tutorial/datediff-sql-function

   The DATEDIFF() function returns the interval between two timestamps or date values in a specified unit. DATEDIFF() syntax. DATEDIFF (datepart, startdate, enddate) Powered By . datepart syntax. The datepart parameter can take in a lot of values, including the following. Year: year, y, yy, or yyyy. Quarter: quarter, qq, q. Month: month, mm, m.

10. SQL DATEDIFF Function Use and Examples - SQL Server Tips

    www.mssqltips.com/sqlservertutorial/9381/sql-datediff-function

    The DATEDIFF function returns the difference between two dates according to the datepart specified: such as year, day, month, etc. Syntax. DATEDIFF(datepart, date1, date2) Parameters. datepart - This is the datepart to get the difference between the two dates.

11. SQL Server: DATEDIFF Function - TechOnTheNet

    www.techonthenet.com/sql_server/functions/datediff.php

    This SQL Server tutorial explains how to use the DATEDIFF function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the DATEDIFF function returns the difference between two date values, based on the interval specified.