SQL Server Gets the maximum time value for the current date _mssql

Then you might ask how to get the maximum time value for the current system date, such as Yyyy-mm-dd 23:59:59.997.

We can use the DateAdd function to implement, with the midnight time value of the current date plus one day, the midnight time value for the second day, then minus 3 seconds, to get the maximum time value of the current system date.

Copy Code code as follows:

DECLARE @Date DATETIME = current_timestamp--Current system date Time

DECLARE @midnight DATETIME
SET @midnight = cast (CAST (@Date as Date) as DATETIME)
SELECT DATEADD (Ms,-3,dateadd (day,1, @midnight))--2011-09-09 23:59:59.997