clintmjohnson/MMDDYYYYto

Created May 14, 2015 21:20

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/clintmjohnson/3d80913903355dd14956.js"></script>
Save clintmjohnson/3d80913903355dd14956 to your computer and use it in GitHub Desktop.

Download ZIP

Usage #3 : Format Date from MMDDYYYY to MM/DD/YYYY

Raw

	DECLARE @MMDDYYYY VARCHAR(10)
	SET @MMDDYYYY = '07042013'

	SELECT STUFF(STUFF(@MMDDYYYY, 3, 0, '/'), 6, 0, '/') AS [MM/DD/YYYY]

Author

clintmjohnson commented May 14, 2015

DECLARE @mmddyyyy VARCHAR(10)
SET @mmddyyyy = '07042013'

SELECT STUFF(STUFF(@mmddyyyy, 3, 0, '/'), 6, 0, '/') AS [MM/DD/YYYY]

Output

07/04/2013

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