<div>
Dim dtr As Date = dtEpoch.AddSeconds(1165449<wbr />600)<br />
&nbsp; &nbsp; &nbsp; &nbsp; MsgBox(&quot;Windows Time: &quot;&nbsp;+ dtDate.ToString)<br />

</div>


Dim dtr As Date = dtEpoch.AddSeconds(1165449600)
        MsgBox("Windows Time: " + dtDate.ToString)


<div>
and to format <br />
MsgBox(&quot;Windows Time: &quot;&nbsp;+ dtr.ToString(&quot;M/d/y hh:mm:ss&quot;, (New Globalization.CultureInfo(<wbr />&quot;en-US&quot;)).<wbr />DateTimeFo<wbr />rmat))
</div>


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

<div>
I have taken the code that you supplied and modified it as follows:<br />
<br />
Dim dtEpoch As Date<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; Dim dtr As Date = dtEpoch.AddSeconds(1195369<wbr />198)<br />
&nbsp; &nbsp; &nbsp; &nbsp; MsgBox(&quot;Windows Time: &quot;&nbsp;+ dtr.ToString)<br />
&nbsp; &nbsp; &nbsp; &nbsp; MsgBox(&quot;Windows Time: &quot;&nbsp;+ dtr.ToString(&quot;M/d/y hh:mm:ss&quot;, (New Globalization.CultureInfo(<wbr />&quot;en-US&quot;)).<wbr />DateTimeFo<wbr />rmat))<br />
<br />
However, the output has the correct M/D but the year and the time are off. &nbsp;Am I missing something?
</div>


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?

<div>
<div class="content wysiwyg-content">
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. &nbsp;However, the one hang up that I am running into is that it stores the date and time in an epoch date format. &nbsp;I have read this posting:<br />
<br />
<a href="https://www.experts-exchange.com/questions/22100727/Convert-date-time-to-Unix-Epoch-time.html" rel="ugc">https://www.experts-exchange.com/questions/22100727/Convert-date-time-to-Unix-Epoch-time.html</a><br />
<br />
but I need it to go the other way.<br />
<br />
How would I accomplish this?<br />
<br />
Any help would be appreciated. &nbsp;Thanks.
</div>
</div>


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.

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

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,