>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.aspxhttp://www.windows-tech.info/15/9115c76955a6a6e1.php
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.