jytioh
06-08-2004, 10:44 PM
I have problem with the server time for daylight saving.
I am hosting my site in the US on a server with daylight saving. But my site is a global site which has users from areas with and without daylight saving. I know how to adjust for difference in time zones using dateadd function. But to cater for daylight saving changes is way more tricky than that.
Eg. Let say the server time in US is GMT -6 hours during non-daylight saving time and GMT -5 during daylight saving. For people with daylight saving, eg. Europe, northern US there won't be problem as their time will be adjusted in the same way. The DateAdd function will be sufficient. However, for places like Malaysia, during the daylight saving period, the server time will be faster by one hour and hence the 'Malaysian time' shown on the server will be one hour faster. How do I go about this to make sure that my site could handle daylight saving changes automatically?
Thank you.
I am hosting my site in the US on a server with daylight saving. But my site is a global site which has users from areas with and without daylight saving. I know how to adjust for difference in time zones using dateadd function. But to cater for daylight saving changes is way more tricky than that.
Eg. Let say the server time in US is GMT -6 hours during non-daylight saving time and GMT -5 during daylight saving. For people with daylight saving, eg. Europe, northern US there won't be problem as their time will be adjusted in the same way. The DateAdd function will be sufficient. However, for places like Malaysia, during the daylight saving period, the server time will be faster by one hour and hence the 'Malaysian time' shown on the server will be one hour faster. How do I go about this to make sure that my site could handle daylight saving changes automatically?
Thank you.