I have a forum app which is hosted in Arizona, but almost all users are here
in Ohio. When a message is posted or replied to, I use
#CreateODBCDate(Now())# which inserts the post to Arizona Time (theire time
zone doesn't seem to follow anyone elses). I'm thinking that a better
solution might be to post to GMT 0 time, then on db query and display, call
the local time zone in Ohio time (EDT).
Two issues:
1) How do I code the date as GMT for insertion to SQL 2000
2) How to I create the time difference for Ohio?
I'm using CFMX 6.1 with Win 2003.
Thanks, Mark
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
