gabrielizalo/GetDateWithoutTime.sql

Created July 8, 2017 00:18

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/gabrielizalo/7f7143f60a5a231b2dd3c1663afdfe8c.js"></script>
Save gabrielizalo/7f7143f60a5a231b2dd3c1663afdfe8c to your computer and use it in GitHub Desktop.

Download ZIP

MS SQL - GetDate without time

Raw

GetDateWithoutTime.sql

SELECT CAST ( FLOOR ( CAST ( GETDATE() AS DECIMAL (12, 5) ) ) AS DATETIME )

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment