?
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
Medium Priority
?
1,245 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
[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
  • 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 750 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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

This tutorial demonstrates one way to create an application that runs without any Forms but still has a GUI presence via an Icon in the System Tray. The magic lies in Inheriting from the ApplicationContext Class and passing that to Application.Ru…
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses

752 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