Following are the functions that you can use in SQL Server instead of NOW() 1. SYSDATETIME() 2. GETDATE () 3. GETUTCDATE() 4. CURRENT_TIMESTAMP. These functions give almost the exact Date and Time while SYSDATETIME gives a more precise time in milliseconds. Query: SELECT SYSDATETIME() Output: 2022-12-21 19:38:49.4181976 More @Wikipedia
Hover over any link to get a description of the article. Please note that search keywords are sometimes hidden within the full article and don't appear in the description or title.