SQL – SQL Server CURRENT_TIMESTAMP Function
The SQL Server CURRENT_TIMESTAMP() function returns the current date and time as “YYYY-MM-DD HH-MM-SS”.
SQL – SQL Server DATEADD() Function
The SQL Server DATEADD() function adds a time/date interval to a date and then returns the date.
SQL – SQL Server DATEDIFF() Function
The SQL Server DATEDIFF() function returns the difference between two dates.
SQL – SQL Server DATEFROMPARTS() Function
The SQL Server DATEFROMPARTS() function returns a date from the specified parts (year, month, and day values).
SQL – SQL Server DATENAME() Function
The SQL Server DATENAME() function returns a specified part of a date as a string value.
SQL – SQL Server DATEPART() Function
The SQL Server DATEPART() function returns a specified part of a date as an integer value.
SQL – SQL Server DAY() Function
The SQL Server DAY() function returns the day of the month (from 1 to 31) for a specified date.
SQL – SQL Server GETDATE() Function
The SQL Server GETDATE() function returns the current database system date and time, in a “YYYY-MM-DD hh:mm:ss.mmm” format.
SQL – SQL Server GETUTCDATE() Function
The SQL Server GETUTCDATE() function returns the current database system UTC date and time, in a “YYYY-MM-DD hh:mm:ss.mmm” format.
SQL – SQL Server ISDATE() Function
The SQL Server ISDATE() function checks an expression and returns 1 if it is a valid date, and 0 if it is NOT a valid date.
SQL – SQL Server MONTH() Function
The SQL Server MONTH() function returns the month part for a specified date (a number from 1 to 12).
SQL – SQL Server SYSDATETIME() Function
The SQL Server SYSDATETIME() function returns the date and time of the computer where the SQL Server is running.
SQL – SQL Server YEAR() Function
The SQL Server YEAR() function returns the year part for a specified date.