DATEFROMTICKS

[Version: 2024 - September]
[Build: 24.09.03003] 

Converts an integer value (ticks) to a DateTime data type.

One 'Tick' is 100 nano-seconds. Ticks are counted from midnight, January 1st, 0001.

(int ticks)
Returns the date representation based on the total amount of ticks passed as parameter.
Example: DateFromTicks(638712000000000000) returns date representation of the date (December 31, 2024).
ticks: Required. The numeric value of total ticks you want to convert to date value.

 

(int ticksbool isSafeCast)
Returns the date representation based on the total amount of ticks passed as parameter.
Example: DateFromTicks(99999999999999999999999999999, true) returns a default date representation of the date (January 1, 0001).
ticks: Required. The numeric value of total ticks you want to convert to date value.

 

(int ticksbool isSafeCastdatetime defaultValue)
Returns the date representation based on the total amount of ticks passed as parameter.
Example: DateFromTicks(99999999999999999999999999999, true, date(2024, 12, 31)) fails with conversion error and returns a default value of the date (December 31, 2024).
ticks: Required. The numeric value of total ticks you want to convert to date value.

 

Examples

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.