keith9820/string to date.sql

Created January 24, 2017 19:15

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/keith9820/94d966053826367c1fe069cd8e686223.js"></script>
Save keith9820/94d966053826367c1fe069cd8e686223 to your computer and use it in GitHub Desktop.

Download ZIP

Raw

string to date.sql

CAST(CAST(year AS VARCHAR(4)) +RIGHT('0' + CAST(month AS VARCHAR(2)), 2) +RIGHT('0' + CAST(day AS VARCHAR(2)), 2) AS DATE)

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