How to Convert Ticks to a Date Format

Formula to convert ticks to a date in excel

I believe you are correct about it being a tick date. This particular one appears to be the number of 100ths of a nanosecond since 01/01/0000. To convert it you can use:

 =(G6*POWER(10, -7) / 60 / 60 / 24)-693593

The 693593 on the end is the number of days between the tick start date and the excel date-type start date.

Format from ticks to date

If logText is a string, you can convert it to long (Int64) and use this constructor:

DateTime date = new DateTime(long.Parse(logText));

How to convert tick into DD/MM/YYYY format where one tick = 1 day

You should be able to just create an instance of DateTime at 1500/1/1:

DateTime startDate = new DateTime(1500, 1, 1);

And then add the number of days you want to it:

DateTime tickDate = startDate.AddDays(tick);

Or simply:

DateTime tickDate = new DateTime(1500, 1, 1).AddDays(tick);

Converting ticks to DateTime

Your value doesn't seem to be a number of ticks; I suspect it's a UNIX timestamp (number of seconds since 1970/01/01 UTC)

Here's a function to convert from a UNIX timestamp:

static readonly DateTime _unixEpoch =
    new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Utc);

public static DateTime DateFromTimestamp(long timestamp)
{
    return _unixEpoch.AddSeconds(timestamp);
}

How to convert ticks from java to DateTime c# with time zone

I solved this issue using DateTimeOffset

var dt = new DateTime(1970, 1, 1, 0, 0, 0, 0).AddSeconds(1448013624577 / 1000d);

var dof = new DateTimeOffset(dt, new TimeSpan(0));

var dtGmt = dof.ToLocalTime().DateTime;

How to convert ticks to datetime in Python?

The following will convert the ticks to a Python datetime object (from now) using datetime's timedelta.

import datetime
ticks = 52707330000
converted_ticks = datetime.datetime.now() + datetime.timedelta(microseconds = ticks/10)

Then something like:

converted_ticks.strftime("%Y-%m-%d %H:%M:%S") // '2015-08-07 14:17:48'

Hope this helps!

EDIT: Using just datetime.timedelta(microseconds = ticks/10) will give you the time, not relative to "now".

Date format \/Date(1394841600000)\/?(In ticks)

It is date in ticks since midnight Jan 1, 1970 to the date of object.

To convert use:

var myDate = new Date("/Date(1394841600000)/".match(/\d+/)[0] * 1);

Here is Demo

PowerShell - Convert Ticks to Time

[DateTime]10000000000
Monday, January 01, 0001 12:16:40 AM

Just cast the number into a DateTime. The DateTime single-parameter constructor takes a long as number of ticks.

How to convert custom time ticks to TDateTime?

TDateTime is actually a floating point value representing the number of days; an hour is represented by 1.0 / 24.0, and a second is represented by 1.0 / SecsPerDay (SecsPerDay is a constant equal to 60 * 60 * 24 = 86400).

So, if one tick is 1.0 / TICKS_PER_SECOND seconds:

TDateTime TimeAsTDateTime = TimeInTicks / (SecsPerDay * TICKS_PER_SECOND)

Also, I think your code is not correct: instead of Ev[0].Leaps+Ev[0].Ticks, as far as I can see you need to use Ev[0].Leaps * TICKS_PER_LEAP + Ev[0].Ticks.

---

Related Topics