Solved

How convert UTC/GMT Time to Date Time in C#

Posted on 2009-07-10
4
3,128 Views
Last Modified: 2013-12-17
I have a numeric field in sql 2000 server, numeric (10,0) not null.It represents the seconds from 1/1/1970.I want to convert this numeric to C# Date Time.
0
Comment
Question by:nikavak
  • 2
4 Comments
 
LVL 28

Expert Comment

by:strickdd
ID: 24822596
This will convert from DateTime to UCTTimestamp so you just need to inverse it.
DateTime temp = ((DateTime)reader["UTCTime"]).ToUniversalTime();

transactionInfo.UtcTimeStamp = (long)temp.Subtract(new DateTime(1970, 1, 1)).TotalMilliseconds;

Open in new window

0
 

Author Comment

by:nikavak
ID: 24822723
I dont understand this solution.I remark that i have a numeric (10,0) sql server field and I want to convert it to local time.This Field means the seconds since 1/1/1970
0
 

Author Comment

by:nikavak
ID: 24823488
I found the following solution

long ccc = 1228893007; //FROM DATABASE
            DateTime temp = new DateTime(ccc *10000000);//for each tick=100 nanoseconds
            DateTime temp1 = new DateTime(1970, 1, 1,00,00,00);
           

           
            DateTime transactionInfo;
            transactionInfo = new DateTime(temp1.Ticks + (ccc*10000000));
            transactionInfo = transactionInfo.ToLocalTime();
           

Best regards,
nikavak
0
 
LVL 1

Accepted Solution

by:
RSBuTCHeR earned 500 total points
ID: 24838956
The solution is very simple. You know the ammount of seconds from 1-1-1970 till the date you want to show.
So you can just add the number of seconds to the date of 1-1-1970.

Best regards,

Falcko
            //Timestamp from database

            long timeStamp = 1000000000;
 

            //Start date (1-1-1970)

            DateTime startDate = new DateTime(1970, 1, 1);
 

            //Calculate the date

            DateTime endDate = startDate.AddSeconds(timeStamp);

Open in new window

0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Flash (http://en.wikipedia.org/wiki/Adobe_Flash) has evolved over the years to where it has become a masterful tool for displaying content screen.  It has excellent layout placement, UI precision as well as rendering capabilities. This, along with t…
Recently while returning home from work my wife (another .NET developer) was murmuring something. On further poking she said that she has been assigned a task where she has to serialize and deserialize objects and she is afraid of serialization. Wha…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…
This is a video that shows how the OnPage alerts system integrates into ConnectWise, how a trigger is set, how a page is sent via the trigger, and how the SENT, DELIVERED, READ & REPLIED receipts get entered into the internal tab of the ConnectWise …

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now