Skip to content

Instantly share code, notes, and snippets.

@kwestground

kwestground/SAPB1_Hana_DateTime.sql

Created March 21, 2022 15:59
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 kwestground/e9cdc7b1a9ec183c4d5b3304f812b3dd to your computer and use it in GitHub Desktop.
Save kwestground/e9cdc7b1a9ec183c4d5b3304f812b3dd to your computer and use it in GitHub Desktop.
Download ZIP
Raw
SAPB1_Hana_DateTime.sql
SELECT TOP 1
T2."UpdateDate", T2."UpdateTS",
CAST(
CAST(T2."UpdateDate" AS date) || ' ' ||
SUBSTRING(RIGHT('0'+ CAST(T2."UpdateTS" AS varchar), 6), 1, 2) || ':' ||
SUBSTRING(RIGHT('0'+ CAST(T2."UpdateTS" AS varchar), 6), 3, 2) || ':' ||
SUBSTRING(RIGHT('0'+ CAST(T2."UpdateTS" AS varchar), 6), 5, 2)
AS datetime)
FROM "ORDR" T2
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment