Friday, October 18, 2013

Find time difference between two dates

 

SELECT
b.backup_finish_date,
b.backup_start_date,
CAST ((b.backup_finish_date - b.backup_start_date) AS TIME(0))
FROM backupset b
WHERE convert(varchar(12),b.backup_finish_date,101) = '10/13/2013'

1 comment:

James Zicrov said...

I feel there is a need to emphasise more on the importance of SQL and its other aspects and utilities as well.

SQL Server Load Soap API