When.com Web Search

Search results

1. Results From The WOW.Com Content Network

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

   stackoverflow.com/questions/2116540

   I can mention four important functions of MS SQL Server that can be very useful: 1) The function DATEDIFF() is responsible to calculate differences between two dates, the result could be "year quarter month dayofyear day week hour minute second millisecond microsecond nanosecond", specified on the first parameter (datepart):

3. Calculate exact date difference in years using SQL

   stackoverflow.com/questions/23145404

   All datediff() does is compute the number of period boundaries crossed between two dates. For instance. datediff(yy,'31 Dec 2013','1 Jan 2014')

4. Calculating number of full months between two dates in SQL

   stackoverflow.com/questions/1106945

   The original post had some bugs... so I re-wrote and packaged it as a UDF. CREATE FUNCTION FullMonthsSeparation ( @DateA DATETIME, @DateB DATETIME ) RETURNS INT AS BEGIN DECLARE @Result INT DECLARE @DateX DATETIME DECLARE @DateY DATETIME IF(@DateA < @DateB) BEGIN SET @DateX = @DateA SET @DateY = @DateB END ELSE BEGIN SET @DateX = @DateB SET @DateY = @DateA END SET @Result = ( SELECT CASE WHEN ...

5. t sql - How to calculate difference in hours (decimal) between...

   stackoverflow.com/questions/1770594

   DATEDIFF(hour, start_date, end_date) will give you the number of hour boundaries crossed between start_date and end_date. If you need the number of fractional hours, you can use DATEDIFF at a higher resolution and divide the result: DATEDIFF(second, start_date, end_date) / 3600.0 The documentation for DATEDIFF is available on MSDN:

6. sql - DATEDIFF in HH:MM:SS format - Stack Overflow

   stackoverflow.com/questions/14445600

   SQL Supports datetime substraction which outputs a new datetime relative to the MIN date (for instance 1900-01-01, you can probably get this value from some system variable) This works better than DATEDIFF, because DATEDIFF will count ONE for each "datepart boundaries crossed", even if the elapsed time is less than a whole datapart.

7. sql - How do you handle NULLs in a DATEDIFF comparison? - Stack...

   stackoverflow.com/questions/10521987

   I have to compare 2 separate columns to come up with the most recent date between them. I am using DATEDIFF(minute, date1, date2) to compare them, however, in some records the date is Null, which r...

8. sql - Calculate Datediff between rows in one column (with more...

   stackoverflow.com/questions/21073666

   SQL: Unable to filter rows using datediff or date_add using reference from the parent query in the ...

9. sql - Include Start Date and the End Date in DateDiff function -...

   stackoverflow.com/questions/25188866

   You may try this in SQL SERVER: DATEDIFF(DAY, '8/4/2014', '8/5/2014') +1 You need to add 1 to the DATEDIFF function and it will work as you want. Also to note that: DATEDIFF. Returns the count (signed integer) of the specified datepart boundaries crossed between the specified startdate and enddate.

10. sql - How to get the average of a DATEDIFF()? - Stack Overflow

    stackoverflow.com/questions/18539417

    SELECT AVG(DATEDIFF(d, DateUsed, DateExpires)) FROM tbl should work fine. Note, that since DATEDIFF returns an integer value, the result also will be an integer. If you want the "exact" (as far as floating point gets) average, use. SELECT AVG(CAST(DATEDIFF(d, DateUsed, DateExpires) AS FLOAT)) FORM tbl

11. MySql using DATEDIFF inside IF clause - Stack Overflow

    stackoverflow.com/questions/11816285

    Also, DATEDIFF returns an int not a date, so you would want to take the return value of DATADIFF and compare it against a known number of days or 0 perhaps, or the return of another DATEDIFF operation.