Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What is this date and time format?

I was wondering if anyone knows this time-format:

  • the value 635872032000000000 represents the 01.Jan 2016.
  • the value 636502752000000000 represents the 31.Dec 2017.

I googled the value and found, that sharepoint is taking this as a parameter too.

Does someone know the format, how to use it or where it's from?

like image 367
dasPanjo Avatar asked Jul 11 '17 11:07

dasPanjo


People also ask

What is date and time format?

A standard date and time format string uses a single character as the format specifier to define the text representation of a DateTime or a DateTimeOffset value. Any date and time format string that contains more than one character, including white space, is interpreted as a custom date and time format string.

How do you write date and time format?

In traditional American usage, dates are written in the month–day–year order (e.g. October 31, 2022) with a comma before and after the year if it is not at the end of a sentence, and time in 12-hour notation (5:28 pm).

What is the time format?

As of ISO 8601-1:2019, the basic format is T[hh][mm][ss] and the extended format is T[hh]:[mm]:[ss]. Earlier versions omitted the T (representing time) in both formats. [hh] refers to a zero-padded hour between 00 and 24. [mm] refers to a zero-padded minute between 00 and 59.


1 Answers

These dates are represented in ticks:

https://msdn.microsoft.com/en-us/library/z2xf7zzk(v=vs.110).aspx

ticks Type: System.Int64

A date and time expressed in the number of 100-nanosecond intervals that have elapsed since January 1, 0001 at 00:00:00.000 in the Gregorian calendar.

e.g. C# code

  long value = 635872032000000000L;

  DateTime result = new DateTime(value);

  Console.Write(result);
like image 113
Dmitry Bychenko Avatar answered Oct 19 '22 16:10

Dmitry Bychenko