I have 2 time zone related questions:
First, the easy one: If I datestamp a record with the datetime returned by the server's 'Now ', when I display this value to the user will it be shown in their local time zone?
Second, a little more tricky:
My web site blocks users from logging in off-hours, for example, I can only allow login monday-friday, 8AM to 5PM based on the local time zone.
To do this I check the server's time using Now.DayOfWeek and Now.Hour. I compare this value to a string value stored in the users profile that indicates times they are allowed to login, in this example, I would store something like Monday,08:00,17:00,Tuesday,08:00...etc...
Will this work with different user time zones???
thanks.
EDIT: after some testing, my question #1 seems to work automatically, that is, a database time of 4PM EDT is displayed as 3PM CDT when viewed in a CDT time zone. This is nice but conc ...
Go to the complete details ...