I have seen in some applications that all dates are stored as the time of the server. This is useful for many reasons! Each user registration contains a field that indicates an offset from the server time. This way all data is store consistenly and the view can use the offset to modify the date/time object to display what the time was in the users location when he/she posted.
DW On Thu, 17 Feb 2005 15:09:11 -0800 (PST), Ashish Kulkarni <[EMAIL PROTECTED]> wrote: > Hi > We have a situtation where we will be hosting our web > server in USA and users from all over the world will > be accessing this, these users will do some > transaction which will update the database. > Now the problem is with date and time, we dont want to > enter system date and time, but the local date and > time for the user, > here are the possible situtation and i need some > suggestions on handling them > 1. How to find out what time zone the user is in? > 2. How to make data updation program use that time > zone to update the database > 3. How to test this function is working, with out > traveling to different parts of world, > Regards > Ashish > > __________________________________ > Do you Yahoo!? > All your favorites on one personal page â Try My Yahoo! > http://my.yahoo.com > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]