Solved

How do you convert an epoch time to a standard Date/Time (m/d/y hh:mm:ss) format?

Posted on 2007-11-19
4
1,238 Views
Last Modified: 2008-02-01
I am in the process of writing a parsing utility that will take the data from our AVL system and populate it into an SQL database.  However, the one hang up that I am running into is that it stores the date and time in an epoch date format.  I have read this posting:

http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Basic.NET/Q_22100727.html

but I need it to go the other way.

How would I accomplish this?

Any help would be appreciated.  Thanks.
0
Comment
Question by:eric_krum
  • 3
4 Comments
 
LVL 18

Expert Comment

by:armoghan
ID: 20311707
Dim dtr As Date = dtEpoch.AddSeconds(1165449600)
        MsgBox("Windows Time: " + dtDate.ToString)
0
 
LVL 18

Expert Comment

by:armoghan
ID: 20311730
and to format
MsgBox("Windows Time: " + dtr.ToString("M/d/y hh:mm:ss", (New Globalization.CultureInfo("en-US")).DateTimeFormat))
0
 

Author Comment

by:eric_krum
ID: 20311977
I have taken the code that you supplied and modified it as follows:

Dim dtEpoch As Date

        Dim dtr As Date = dtEpoch.AddSeconds(1195369198)
        MsgBox("Windows Time: " + dtr.ToString)
        MsgBox("Windows Time: " + dtr.ToString("M/d/y hh:mm:ss", (New Globalization.CultureInfo("en-US")).DateTimeFormat))

However, the output has the correct M/D but the year and the time are off.  Am I missing something?
0
 
LVL 18

Accepted Solution

by:
armoghan earned 250 total points
ID: 20312117
Following would be Complete code.
as 1165449600 stands for 12/07/2006 so time would be 12:00:00 AM
  Dim dtEpoch As Date = "1/1/1970"
     Dim dtr As Date = dtEpoch.AddSeconds(1165449600)
        MsgBox("Windows Time: " + dtr.ToString("MM/dd/yyyy hh:mm:ss tt", (New Globalization.CultureInfo("en-US")).DateTimeFormat))
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
update textboxes with Streamreader 21 47
Put window Form inside tab page 10 33
Help with exporting to excel 4 28
VB.Net Tranfer data between to VB.Net apps 8 27
Introduction As chip makers focus on adding processor cores over increasing clock speed, developers need to utilize the features of modern CPUs.  One of the ways we can do this is by implementing parallel algorithms in our software.   One recent…
1.0 - Introduction Converting Visual Basic 6.0 (VB6) to Visual Basic 2008+ (VB.NET). If ever there was a subject full of murkiness and bad decisions, it is this one!   The first problem seems to be that people considering this task of converting…

831 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