+- LogicMachine Forum (https://forum.logicmachine.net)
+-- Forum: LogicMachine eco-system (https://forum.logicmachine.net/forumdisplay.php?fid=1)
+--- Forum: Scripting (https://forum.logicmachine.net/forumdisplay.php?fid=8)
+--- Thread: Time Format (/showthread.php?tid=4440)
Time Format - tomnord - 12.12.2022
Hello, could anybody tell me how to format LM time to this format and vise versa?
Code:
/Date(1670926903419+0100)/RE: Time Format - admin - 12.12.2022
It's a timestamp in milliseconds with timezone.
Current date/time to string conversion:
Code:
tz = os.date('%z')
ts, tu = os.microtime()
str = string.format('/Date(%d%03d%s)/', ts, tu / 1000, tz)
log(str)Convert string to date/time:
Code:
str = '/Date(1670926903419+0100)/'
time = tonumber(str:match('%d+'))
ts = math.floor(time / 1000) -- timestamp in seconds
tm = time % 1000 -- millisecond part of the timestamp
date = os.date('%c', ts) -- readable date from timestamp
log(date, ts, tm)RE: Time Format - tomnord - 12.12.2022
(12.12.2022, 10:36)admin Wrote: It's a timestamp in milliseconds with timezone.
Current date/time to string conversion:
Code:tz = os.date('%z')
ts, tu = os.microtime()
str = string.format('/Date(%d%03d%s)/', ts, tu / 1000, tz)
log(str)
Convert string to date/time:
Code:str = '/Date(1670926903419+0100)/'
time = tonumber(str:match('%d+'))
ts = math.floor(time / 1000) -- timestamp in seconds
tm = time % 1000 -- millisecond part of the timestamp
date = os.date('%c', ts) -- readable date from timestamp
log(date, ts, tm)
Thanks!
And if I wanted to at for example 24h to the "str" string, to use as a from-to range?
RE: Time Format - admin - 12.12.2022
You can add 86400 to ts variable.