HighTechTalks DotNet Forums  

Storing Gloabal DateTime Values in Local Database

Dotnet Internationalization microsoft.public.dotnet.internationalization


Discuss Storing Gloabal DateTime Values in Local Database in the Dotnet Internationalization forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
The Fox
 
Posts: n/a

Default Storing Gloabal DateTime Values in Local Database - 06-25-2004 , 01:43 AM






Hi all,

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
record)
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.



Reply With Quote
  #2  
Old   
Aldo Donetti [MS]
 
Posts: n/a

Default 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
accepting input.

Aldo

"The Fox" <bensmile (AT) hotmail (DOT) com> wrote

Quote:
Hi all,

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
record)
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.





Reply With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.