MrChrisWeinert/Excel Date Format for SQL datetime

Last active July 6, 2023 20:52

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/MrChrisWeinert/6c99aa96fb4860242d66ceefaf25256c.js"></script>
Save MrChrisWeinert/6c99aa96fb4860242d66ceefaf25256c to your computer and use it in GitHub Desktop.

Download ZIP

This is the Excel Date Format to use that will properly display SQL server's datetime data type.

Raw

Excel Date Format for SQL datetime

	yyyy-mm-dd hh:mm:ss.000
	or
	dd-mmm-yy hh:mm AM/PM

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