I was wondering if anyone knows this time-format:
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?
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.
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).
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.
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);
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With