Hi,
I have been using MSSQL for a while and observed that the Getdate() always returns manipulated time.
Like the last digit of the time is always 0,3 or 7



I want to know how its works.

Hi,
I have been using MSSQL for a while and observed that the Getdate() always returns manipulated time.
Like the last digit of the time is always 0,3 or 7



I want to know how its works.

Getdate() always returns manipulated time. Like the last digit of the time is always 0,3 or 7
It's not manipulated"; GetDate() returns a vlaue of data type "datetime" and datetime do have a Accuracy of 3 1/3 milliseconds and thats well documented at datetime (Transact-SQL) => Accuracy
This query
select convert(datetime, '20210525 23:59:59.999')
returns 2021-05-26 00:00:00.000
If you need higher precision you need to use datetime2 and sysdatetime.
https://docs.microsoft.com/en-us/sql/t-sql/functions/sysdatetime-transact-sql?view=sql-server-ver15
14 people are following this question.
Year and Month aggregation in same Pivot table in SQL Server
SQL Server Query for Searching by word in a string with word breakers
How to show first row group by part id and compliance type based on priorities of Document type?
Query to list all the databases that have a specific user
T-sql query to find the biggest table in a database with a clustered index