SQL Server Operations Studio and VSCode: The wrong default datetimeoffset format
This post is to answer the question: “You are used to seeing in the format of
yyyy-MM-dd right?” that I have raised on my blog post Don’t cutoff yourself with dates in T-SQL – Did you know….
“But why are my datetimeoffset values on VSCode being showed in that format?” (dd-MMM-yyyy)
The short answer is because it relies on your regional settings.
This means that whatever settings you have set for your date when you open the VSCode or SQL Operations Studio this will be used to show the output from your
I’m being specific when I mean
DATETIME2 types already display always in
yyyy-MM-dd format like SQL Server Management Studio.
Once again, remember, I’m talking about default output not if you use a
FORMAT function to manipulate the results.
How can we fix this?
When I was looking for this behaviour I did some research and found that a similar problem was raised but regarding
DATETIME2. You can see it here - issue #570.
With this in mind, I decided to open an new issue (#1139) on the vscode-mssql extension repository on GitHub and point to the other one already solved.
If you identify yourself with it, please add your “+1” to the issue.
Now, we need to wait to see the evolution and, hopefully, a fix will be included on a upcoming release.
Always try to use an unambiguous date format like “yyyy-MM-dd”.
Remember, copying things that can have double meaning (incorrect format) can lead to unexpected results like I have shown on the other blog post.
And last but not least, if you think is a bug/missing feature please take the time to fill an issue. It will help you an others for sure!
Thanks for reading!