ronascentes/truncate_date.sql

Created October 1, 2016 21:07

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/ronascentes/1544d810cf3159645379daf06ae5cb96.js"></script>
Save ronascentes/1544d810cf3159645379daf06ae5cb96 to your computer and use it in GitHub Desktop.

Download ZIP

How to truncate date in T-SQL

Raw

truncate_date.sql

CONVERT(VARCHAR(10), LAST_LOAD_DATE, 101) < CONVERT(VARCHAR(10), GETDATE(), 101)

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