Skip to content

Instantly share code, notes, and snippets.

@dexMargera

dexMargera/gist:1d02299cb822810dc901fcf0770dd6b7

Created June 28, 2016 09:03
Show Gist options
  • Save dexMargera/1d02299cb822810dc901fcf0770dd6b7 to your computer and use it in GitHub Desktop.
Save dexMargera/1d02299cb822810dc901fcf0770dd6b7 to your computer and use it in GitHub Desktop.
Download ZIP
trunc like oracle in mssql
Raw
gistfile1.txt
mssql:
SELECT CONVERT(DATETIME, ((CONVERT(VARCHAR(10), GETDATE(), 104)) + ' ' + (CONVERT(VARCHAR(2), GETDATE(), 8)) + ':00:00'));
SELECT CONVERT(DATETIME, ((CONVERT(VARCHAR(10), GETDATE(), 104)) + ' ' + CONVERT(VARCHAR(2), ((CONVERT(VARCHAR(2), GETDATE(), 8))-1)) + ':00:00'));
oracle:
SELECT trunc(sysdate, 'hh24') FROM dual;
SELECT trunc(sysdate, 'hh24')-1/24 FROM dual;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment