> I use the AT TIME ZONE functionality from SQL, it even
> compensates for daylight savings time...
Thanks Jochem, Tony, Tim, Novak, et. al.
I'll look into your recommendations.
I should have clarified the situation a bit more, however. The database
is MS Access (for now; will probably upsize to MS SQL server soon). I
want to keep this is simple as possible (because I'm a simple person). I
am going to assume that the user's time zone is always local because my
client's business is local. So, in effect, I need only subtract one hour
from the server's time for any transaction (storing appointment times,
mainly). I guess I could set this as a constant in a request variable in
the application.cfm file and then use that for the current time from
then on. Would that seem feasible?
Cheers.
--
Chris Montgomery
Airtight Web Services http://www.airtightweb.com
Web Development, Web Project Management, Software Sales
210-490-2415
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
