Hi all,

I have my ASP application worked fine in my production server. My DBA just
set up another development server but with problem on the datetime.

In prod. server, date are appeared as US format, but UK format in develop
server. I have already hard coded Session.LCID=1033 in my ASP.

Default collation from production server:

Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive,
width-insensitive for Unicode Data, SQL Server Sort Order 52 on Code Page
1252 for non-Unicode Data

Default collation from develop server:

Latin1-General, binary sort for Unicode Data, SQL Server Sort Order 30 on
Code Page 437 for non-Unicode Data

Does the above collations explain the date difference? Please advise.

Thanks
William