Function Syntax Return value Return data type Determinism SYSDATETIME Returns a datetime2 7 value containing the date and time of the computer on which the instance of SQL Server runs.
Days Between Dates & Time Between Dates Calculator
dd-mm-yyyy For international date formatting style according to use only a dash - :• Provides information about the conversion of date and time values to and from string literals, and other date and time formats.