Resource Dynamics, Inc.

Tele-Support HelpDesk Hot Tips

Tech Tip:

Date / Time Format Differences on Server and Client Computers Using SQL

If the client and server computers use date formats that order the date elements (month, day, year) differently (e.g. Client uses mm/dd/yyyy and Server uses dd/mm/yyyy), an error may be caused in SQL. This is due to the fact that the Client will write to the SQL database using its native format while the Server will be looking for the date / time in its own native format. An error may not occur for several days, until the day element of the client date stamp rises above 12.