Australian Date Format problems on SQL 7

[Suvir]

We are having problems with an Australian system due to the different date format. All PCs are set to dd/mm/yy. When we get a datetime stamp from these PCs and then try to insert a record into the database, the month and day get flipped around. We tried using the US standard date format but SQL 7 flipped that around too. We eventually grabbed the date from the PCs, extracted the moth and day and flipped them to the US standard before inserting them into the database which would then flip it into the Australian format.

Why does this month, day swap occur and how do we stop it?

Thanks in advance.

Suvir Salins.

[Simon]

If you set the default language for the appropriate user to British English, you don't need to do any swapping. The default language when sql server is installed is US English and this is what's causing your problem.


------------
Suvir at 7/5/01 8:54:41 PM

We are having problems with an Australian system due to the different date format. All PCs are set to dd/mm/yy. When we get a datetime stamp from these PCs and then try to insert a record into the database, the month and day get flipped around. We tried using the US standard date format but SQL 7 flipped that around too. We eventually grabbed the date from the PCs, extracted the moth and day and flipped them to the US standard before inserting them into the database which would then flip it into the Australian format.

Why does this month, day swap occur and how do we stop it?

Thanks in advance.

Suvir Salins.