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.

The SQL Server MONTH() function returns the month part for a specified date (a number from 1 to 12).

The SQL Server SYSDATETIME() function returns the date and time of the computer where the SQL Server is running.

The SQL Server YEAR() function returns the year part for a specified date.