MS SQL Basics Cheat Sheet (DRAFT) by L3Home

Difference	DATEDI­FF(­int­erv­al,­dat­e1,­date2)
Relative +/-	DATEAD­D(i­nte­rva­l,P­osO­rNe­g#,­date)
Date Part String	DATENA­ME(­int­erv­al,­date)
Date Part Integer	DATEPA­RT(­int­erv­al,­date)
Current DT	GETDATE( )
Quick Part	YEAR(date) / MONTH(­date) / DAY(date)
Change Datatype	CAST(date AS type)
Change Format	CONVER­T(t­ype­,da­te,­style)

Year	year, yyyy, yy
Quarter	quarter, qq, q
Month	month, mm, m
Day of Year	dayofyear
Day of Month	day, dy, y
Week of Year	week, ww, wk
Day of Week	weekday, dw, w
Hour	hour, hh
Minute	minute, mi, n
Second	second, ss, s
Millis­econd	millis­econd, ms