Handy Code Snippets
--- SET TIME FROM DATETIME SELECT Convert(TIME, GetDate()) SELECT (CONVERT([time],getdate()))