UTC/GMT dates...

  • Thread starter Thread starter José Araujo
  • Start date Start date
J

José Araujo

Hi,

I am developing an application that is used in Spain and USA.

That application saves its information in a MSSQL server, some tables have a
date field, I am thinking on setting those fields to use UTC date (using
GETUTCDATE() when filling them).

Given that i have a way to storage the dates in UTC format, how can i
develop my UI so it displays the correct values?

Thanks, José.
 
José Araujo said:
Hi,

I am developing an application that is used in Spain and USA.

That application saves its information in a MSSQL server, some tables
have a date field, I am thinking on setting those fields to use UTC
date (using GETUTCDATE() when filling them).

Given that i have a way to storage the dates in UTC format, how can i
develop my UI so it displays the correct values?
Click to expand...

DateTime dt = <value from database>

dt.ToLocalTime()

http://msdn.microsoft.com/library/default.asp?url=/library/en-
us/cpref/html/frlrfsystemdatetimememberstopic.asp

--
Greetings
Jochen

My blog about Win32 and .NET
http://blog.kalmbachnet.de/
 
Back
Top