Since I have a lot of trouble based on SQL Server in different languages, I have encountered a lot of trouble, in which the DateTime data class is most, Chinese, Korean and other databases are: mm / dd / yy or yy / mm / DD but in English is divided into: mm / dd / yy or dd / mm / yy this problem is coming, for example, a Korean customer, operating system: Windows 2000 Server English, MS SQL Server Korean version of his host New Zealand, the time system defaults to the New Zealand DD / MM / YY database time defaults to: mm / dd / yy When the database update time, or execute the time query command, such as select update_timeFrom ORDETAILSWHERE UPDATE_TIME> Convert (DateTime, 'VardateInput', 121) VardateInput = 16/11/2004 In the practice default, the host or client last time is November 16 but the database time is default: MM / DD / YY error is immediately made, it is very simple, here I Not much to say, just today, I hope that China's "master" can pay attention to these "internationalization" requirements to avoid some "low" mistakes, using time to write more, updated ideas Program on
Sometimes simple questions can harass our valuable time for a few days, only from everyone, welcome everyone to communicate!
