Home Forums Article Discussions Article Discussions by Author Discuss content posted by Pradeep Singh Enterprise wide Backup Audit RE: Enterprise wide Backup Audit
ps.
One Orange Chip
Points: 29422
More actions
August 6, 2010 at 9:23 am
#1203606
BlackHawk-17 (8/6/2010)To calculate the duration you may find this a little better than the method you are currently using:CONVERT(CHAR(8), backup_finish_date - backup_start_date, 8) AS [Duration]
BlackHawk-17 (8/6/2010)
CONVERT(CHAR(8), backup_finish_date - backup_start_date, 8) AS [Duration]
Thanks for the feedback. Will implement it.