calculate the time difference between two dates in hours and minutes in sql
Take Survey. Omosanya93 Regular Visitor. The difference between the startdate and enddate in each statement crosses one calendar or time boundary of its datepart. Showing results for. Here are some test cases with your expression and two variations of mine. You don't seem to have tested for cases with minutes, your expression turns them into minutes. You could use this for a table calculation, but it does not pad zeros in the case of single digits d:h:m:s format :.
Get StartedCALCULATE THE TIME DIFFERENCE BETWEEN TWO DATES IN HOURS AND MINUTES IN SQL / janiceclark.net
- Secure and Private
- Easy to Use
- Find Matches Quickly
- Verified Profiles