Storing Gloabal DateTime Values in Local Database - 06-25-2004 , 01:43 AM
I have a local database and web services in HK.
Applications users call the web servers from different countries,
such as AU, US, etc.
I must store the DateTime value (such as CreateDateTime value for a
in user's DateTime (AU, US, etc) and NOT in HK's DateTime.
E.g., User A create a product in AU (or in US) time in user's local PC,
call the web services in HK and store the date time in AU (or US) time.
I have passed the AU (or US) Time to the web services,
but the web services automatically convert to HK time!
How can I store in AU (or US) time?
Thanks in advance.
Re: Storing Gloabal DateTime Values in Local Database - 06-28-2004 , 02:09 PM
The easier would be to convert all DateTimes to UTC for internal processing
purposes and then convert to the User locale format when displaying or
"The Fox" <bensmile (AT) hotmail (DOT) com> wrote
|Thread Tools||Search this Thread|