t-sql display date, time, time period

Quick post on how to display date, time, and time period in T-SQL: