Date and Time Parts

sql server offers us a few functions when working with time, in this article I am going to explain the functions that we can use to get date and time parts.  The functions that we have are:

 

DATEFROMPARTS

SMALLDATETIMEFROMPARTS

DATETIMEFROMPARTS

DATETIME2FROMPARTS

DATETIMEOFFSETFROMPARTS

TIMEFROMPARTS

DATENAME

DATEPART

EOMONTH

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *