Find last backup start time and finish time for all databases – SQL Server

select database_name,backup_start_date,backup_finish_date from msdb.dbo.backupset where backup_set_id in (select max(backup_set_id) from msdb.dbo.backupset where type=’D’ group by database_name)