Function zulutomsec

GeneralizedTime or UTCTime string to milliseconds from Unix origin

Description

This function converts from GeneralizedTime string (i.e. YYYYMMDDHHmmSSZ) or UTCTime string (i.e. YYMMDDHHmmSSZ) to milliseconds from Unix origin time (i.e. Jan 1 1970 0:00:00 UTC). Argument string may have fraction of seconds and its length is one or more digits such as "20170410235959.1234567Z". As for UTCTime, if year "YY" is equal or less than 49 then it is 20YY. If year "YY" is equal or greater than 50 then it is 19YY.

Example

zulutomsec(  "071231235959Z")       -> 1199145599000 #Mon, 31 Dec 2007 23:59:59 GMT
zulutomsec(  "071231235959.1Z")     -> 1199145599100 #Mon, 31 Dec 2007 23:59:59 GMT
zulutomsec(  "071231235959.12345Z") -> 1199145599123 #Mon, 31 Dec 2007 23:59:59 GMT
zulutomsec("20071231235959Z")       -> 1199145599000 #Mon, 31 Dec 2007 23:59:59 GMT
zulutomsec(  "931231235959Z")       -> -410227201000 #Mon, 31 Dec 1956 23:59:59 GMT
Copy