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]

Reply via email to