Skip to content

Instantly share code, notes, and snippets.

@davidsheardown
Created October 5, 2020 13:39
Show Gist options
  • Save davidsheardown/d3d69c24c9cd340e2874ee37b437fb40 to your computer and use it in GitHub Desktop.
Save davidsheardown/d3d69c24c9cd340e2874ee37b437fb40 to your computer and use it in GitHub Desktop.
Return ISO date the easy way!
/*
Replace "getdate()" with whatever date you need i.e. a field
*/
select convert(nvarchar(17),getdate(),127)+'00.00Z' as myISOdate
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment