SQL server default language english- datetime & time columns
Posted on 2015-01-22
I'm working on a large product that has hundreds of queries that involve DateTime and Time columns on SQL Server. We are experiencing a problem when our application uses an SQL server where the default language is not English.
The reason- we are using the format string "YYYY-MM-DD hh:mm:ss" and not "YYYY-MM-DDThh:mm:ss"
So my question is, are there any shortcuts for me here? Is the best case to go through each query that touches a DateTime or Time column and change it to this format? When reading from the database, will I have to convert again?
I know this is vague, but I'm at the "trying to understand the problem" phase.