select getdate() select format(getdate(),'yyyy-MM-dd hh:mm tt')
SELECT CONVERT(DATE, GETDATE()) date;
DECLARE @date DATETIME = '2006-12-30 00:38:54.840'