Last post Mar 31, 2007 04:04 PM by colinbo
Mar 22, 2007 01:48 PM|Tobin|LINK
I have a need to "time stamp" and activity that occurs. The issue I'm having is the time stamp always uses the web server's local time when it writes to the SQL database.
Since I have mobile users accessing these pages from all over the U.S., I've been trying to figure out a way to retrieve the date and time from the mobile device.
Does anyone know of a way to retrieve the local time from a mobile device or some other workaround?
On last caveat... The option to store the time as UDT and diplay based on time zone differential is not an option since there are other applications using the data not under my control that would not be able to perform this conversion.
Thank you in advance for any suggestions.
Mar 28, 2007 09:43 AM|Tobin|LINK
I was able to engineer a work around. I made a setting entry in the local database to adjust the date/time stamp based on the offset value. This setting is used in the conversion of the reported datetime to the local datetime using the DateAdd() function.
This allows for different companies to have different databases and time zones on the same server.
Mar 31, 2007 04:04 PM|colinbo|LINK
I would lean towards storing time stamps in UTC and then convert it to the user's time zone. That way it becomes a display issue that can be handled through: