Chandrashekar
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))))Get last minute of day example "2018-06-19 23:59:59.997"
select dateadd(ms, -3, (dateadd(day, +1, convert(varchar, GETDATE(), 101))))