Skip to content

Instantly share code, notes, and snippets.

@kwestground

kwestground/SBOTimeIntToTime.sql

Created June 8, 2016 12:58
Show Gist options
  • Save kwestground/f072e6fb5fab0ce92cf6d405265844b2 to your computer and use it in GitHub Desktop.
Save kwestground/f072e6fb5fab0ce92cf6d405265844b2 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
SBOTimeIntToTime.sql
SELECT
CAST(SUBSTRING(RIGHT('0'+ CAST([Time] AS varchar), 6), 1, 2) + ':' +
SUBSTRING(RIGHT('0'+ CAST([Time] AS varchar), 6), 3, 2) + ':' +
SUBSTRING(RIGHT('0'+ CAST([Time] AS varchar), 6), 5, 2) AS time)
FROM [USR5]
ORDER BY [Time]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment