sql server date function

SQL DATEFROMPARTS

SQL DATEFROMPARTS() function is a date function that returns a date value that maps to a year, month, and day values.

SQL EOMONTH() function is a date function , it returns the last day of the month of a specified date, with an optional offset.