--When I run below SQL,
backup_size/1024000000 as backupsize,
datediff(MINUTE,backup_start_date, backup_finish_date) Minute
where backup_start_date > GETDATE() - 1
and type = 'D'
and datediff(MINUTE,backup_start_date, backup_finish_date) > 1
order by backup_start_date
select * from msdb.dbo.backupset;
--I get below result. I'd like to remove numbers after period(.) under backupsize column and want to have only year month and date not time under backup_start_date column. How should I change the above SQL?
View Complete Post