enow.com Web Search

Search results

1. Results from the WOW.Com Content Network

2. How do I find the time difference between two datetime objects in...

   stackoverflow.com/questions/1345827

   If a, b are datetime objects then to find the time difference between them in Python 3: from datetime import timedelta time_difference = a - b time_difference_in_minutes = time_difference / timedelta (minutes=1) On earlier Python versions: time_difference_in_minutes = time_difference.total_seconds () / 60. If a, b are naive datetime objects ...

3. Calculate difference between 2 date / times in Oracle SQL

   stackoverflow.com/questions/1096853

   You can substract dates in Oracle. This will give you the difference in days. Multiply by 24 to get hours, and so on. SQL> select oldest - creation from my_table; If your date is stored as character data, you have to convert it to a date type first. SQL> select 24 * (to_date('2009-07-07 22:00', 'YYYY-MM-DD hh24:mi')

4. java - Find total hours between two Dates - Stack Overflow

   stackoverflow.com/questions/2003521

   A Joda Period is divided into a number of fields and the getXXX methods only return the value of a specific field (e.g. for a period of 2 days, 2 hours, 30 minutes, getHours will return 2, not 50 (2*24+2). The correct way to "Find total hours between two Dates" with Joda is per Somaiah's comment. –

5. How to get total number of hours between two dates in sql server?

   stackoverflow.com/questions/2475178

   Or using Will's answer using [min] for minutes: CAST(DATEDIFF(mi, date1, date2) AS NUMERIC(18,4)) / 60 AS [HrsDiff] So the minute total is divided by 60 to give you the hours. The first option gives you a big decimal, whereas the 2nd option rounds it up to the nearest decimal. answered Dec 14, 2021 at 5:38.

6. How to get total number of hours between two dates in javascript?

   stackoverflow.com/questions/29600147

   var date2 = new Date("7 May, 2015 02:45"); then you can simply get the timestamp of the two dates and find the difference. var difference = Math.abs(date1.getTime() - date2.getTime()); Now to convert that to hours simply convert it first to seconds (by dividing by 1000 because the result is in milliseconds), then divid it by 3600 (to convert it ...

7. Calculate number of hours between 2 dates in PHP

   stackoverflow.com/questions/3108591

   How do I calculate the difference between two dates in hours? For example: day1=2006-04-12 12:30:00 day2=2006-04-14 11:30:00 In this case the result should be 47 hours.

8. How can I get the difference in hours between two dates?

   stackoverflow.com/questions/9488475

   I have to do a "select" that returns the difference between a field of type date from the database and the current date in hours. How can I do this in oracle? I try this: select 24 * (to_date(

9. How to calculate difference in hours (decimal) between two dates...

   stackoverflow.com/questions/1770594

   I have to calculate the difference in hours (decimal type) between two dates in SQL Server 2008. I couldn't find any useful technique to convert datetime to decimal with 'CONVERT' on MSDN. Can anybody help me with that? UPDATE: To be clear, I need the fractional part as well (thus decimal type). So from 9:00 to 10:30 it should return me 1.5.

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

    stackoverflow.com/questions/2116540

    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): select datediff(day,'1997-10-07','2011-09-11') 2) You can use the function GETDATE () to get the ...

11. SQL time difference between two dates result in hh:mm:ss

    stackoverflow.com/questions/13577898

    I am facing some difficulty with calculating the time difference between two dates. What I want is, I have two dates let say @StartDate = '10/01/2012 08:40:18.000' @EndDate='10/04/2012 09:52:48.000' so the difference between two dates in the form of hh:mm:ss is 72:42:30. How can I get this result in a T-SQL query?