Solved

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

Posted on 2009-07-10
4
3,146 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

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…
This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

622 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