Home Forums Article Discussions Article Discussions by Author Discuss content posted by Ashish Gilhotra Backup & Restoration Script RE: Backup & Restoration Script
svedantam
SSC Enthusiast
Points: 174
More actions
July 1, 2010 at 12:17 pm
#1187840
The following formats the duration in HH:MI:SS.
CONVERT( VARCHAR(8), DATEADD( SECOND, DATEDIFF( second, s.backup_start_date, s.backup_finish_date ), 0 ), 114 )