chandu1551
6/19/2018 - 1:53 PM

Get last minute of day of given date

Get last minute of day example "2018-06-19 23:59:59.997"

select dateadd(ms, -3, (dateadd(day, +1, convert(varchar, GETDATE(), 101))))