ms sql create date from parts code example Example 1: datefromparts mssql DATEFROMPARTS ( year, month, day ) Example 2: sql display today's date SELECT getdate()