Storing Gloabal DateTime Values in Local Database -- dotnet internationalization

The Fox
6/25/2004 2:43:34 PM

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.

Aldo Donetti [MS]
6/28/2004 12:09:26 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

[quoted text, click to view]

dotnet internationalization : Storing Gloabal DateTime Values in Local Database