jaccorens/fm_epoch_to_timestamp.txt

Created February 21, 2016 10:01

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/jaccorens/d04a3c3d02b3375222b5.js"></script>
Save jaccorens/d04a3c3d02b3375222b5 to your computer and use it in GitHub Desktop.

Download ZIP

unix epoch timestamp to FileMaker timestamp

Raw

fm_epoch_to_timestamp.txt

GetAsTimestamp ( ( GetAsNumber ( epoch ) )  + GetAsNumber ( Timestamp ("01/01/1970" ; "00:00:00" ) ) )

bn0 commented Sep 17, 2019 •

edited

And back again (timestamp to epoch):

GetAsNumber($timestamp) - GetAsNumber(Timestamp("01/01/1970"; "00:00:00")) - (GetAsNumber(Get(CurrentTimestamp)) - Int(Get(CurrentTimeUTCMilliseconds)/1000))

Author

jaccorens commented Sep 27, 2019

Excellent, thanks

bcrisler commented Feb 19, 2023

THANK YOU!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment