>>Hi,
>>I am developing an application which would supports multiple country (one country per database/application). How could I manage the datetime for each country application/database which reside at the same server? For example, store datetime value and display current datetime based on specified timezone. Any other thing need to be considered?
>>
>>Thank you
>
>Instead of using GETDATE() function use GETUTCDATE() function. That will return UTC date time. Then when user wants date back you should convert it to Local time:
>
http://www.codeproject.com/KB/database/ConvertUTCToLocal.aspx>
>
http://www.windows-tech.info/15/9115c76955a6a6e1.phpI haven't checked, but was this function introduced in SQL Server 2008?
If it's not broken, fix it until it is.
My Blog