Toad's generated Date format is not compatible with SQL Server YMD date format (4236973)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Toad's generated Date format is not compatible with SQL Server YMD date format
Description

In v3.5, when generating a query with the SQL Query Builder, the date Toad generates when using a Date Range or the Form does not generate any results if the database format is Year/Month/Day (YMD). This is because the date format being generated by Toad is not compatible with the SQL Server database format, and makes statements return no data
Resolution

There isn't a setting in Toad that can change this format, however assigning a user a certain language can fix this issue.
For example, if you run the statement:

EXEC sp_defaultlanguage 'USER_NAME', 'ENGLISH'
SET DATEFORMAT ymd;
Then run Toad with this user. The date format Toad creates will be valid to the database format

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title