UTC/GMT dates...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jos? Araujo - 31 Aug 2004 19:20 GMT

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?.

Reply to this Message

Jochen Kalmbach - 31 Aug 2004 19:27 GMT

> Hi,
>
[quoted text clipped - 6 lines]
> 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?

DateTime dt = <value from database>

dt.ToLocalTime()

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

Signature

Greetings
Jochen

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

Reply to this Message

Rate this thread:

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...