Solved

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

Posted on 2009-07-10
4
3,130 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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
.net and XML report from SCCM 5 25
MVC DDL Json Not Binding to Model 2 13
location of a form 2 15
parsing JSON help 1 10
This article describes relatively difficult and non-obvious issues that are likely to arise when creating COM class in Visual Studio and deploying it by professional MSI-authoring tools. It is assumed that the reader is already familiar with the cla…
For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

821 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