How do I translate PRTG timestamp values format to normal time format?

Converting the timestamp value using vb.net

This little vb.net function converts the timestamp value to a normal date and time string:

Public Shared Function TimeRaw2String(ByVal timeRaw As String, Optional ByVal timeOnly As Boolean = False) As String Dim d As DateTime = System.TimeZone.CurrentTimeZone.ToLocalTime(DateTime.FromOADate(CDbl(timeRaw.Replace(".", System.Globalization.NumberFormatInfo.CurrentInfo.NumberDecimalSeparator)))) If timeOnly Then Return d.ToLongTimeString Return d.ToShortDateString & " " & d.ToLongTimeString End Function

Hello, is it possible to convert this kind of timestamp with PHP or Javascript?

Converting prtg timestamp value using php

function prtg_timestamp_to_unix_timestamp ($prtg_timestamp) {
	if (!is_numeric($prtg_timestamp)) return $prtg_timestamp;
	$past = ($prtg_timestamp-25569)*86400;
	$unix_timestamp = $now-$past;
	return $unix_timestamp;
}

I cannot get Excel to understand the format. The way I understand the first answer it should be able to work with it nativley - but how?

I have a column with values like 414.172.868.055.556 - when I set the datatype for that column to "date" or "time" all I get is ############### ... maybe this is more of an Excel question but still.

Thanks!

The columns that have the date and time values will have a value similar to 41430.66667 which should translate with excel into 6/5/2013. Where are you exporting this data from to get values like the one shown above?

Since the data is the number of days since December 30, 1899, then can convert it to seconds

Examples:

• in Javascript using this modified Gist:

// Convert Excel dates into JS date objects
//
// @param excelDate {Number}
// @return {Date}

function getJsDateFromExcel(excelDate) {

  // JavaScript dates can be constructed by passing milliseconds
  // since the Unix epoch (January 1, 1970) example: new Date(12312512312);

  // 1. Subtract number of days between Dec 30, 1899 and Jan 1, 1970            
  // 2. Convert to milliseconds.

	return new Date((excelDate - 25569) * 86400 * 1000);

• in R using the as.POSIXlt function:

> as.POSIXlt(x = 40190.5279598380 * 86400, origin = "1899-12-30")
[1] "2010-01-12 04:40:15 PST"

using powershell [datetime]$utc = [System.DateTime]::FromOADate(40190.5279598380)

Or using Python:

from datetime import datetime

datetime.fromtimestamp((42743.2113998495-25569)* 86400)

Cool, thanks for sharing! :)