Skip to content

Instantly share code, notes, and snippets.

@wellercs

wellercs/tsql_DisplayDateTimeAndTimePeriod

Created July 27, 2012 23:04
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save wellercs/3190931 to your computer and use it in GitHub Desktop.
Save wellercs/3190931 to your computer and use it in GitHub Desktop.
Download ZIP
t-sql display date, time, time period
Raw
tsql_DisplayDateTimeAndTimePeriod
SELECT
GETDATE() AS this_date_time
, CONVERT(VARCHAR, GETDATE(), 101) AS this_date
, RIGHT(CONVERT(VARCHAR, GETDATE(), 100),7) AS this_time
, ( CONVERT(VARCHAR, GETDATE(), 101) + ' ' + RIGHT(CONVERT(VARCHAR, GETDATE(), 100),7) ) AS this_date_time
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment