ph_fromunixtime PowerHome formula function
Description
Converts a longlong value in standard Unix
time (number of seconds past midnight, Jan 1, 1970) into a standard
PowerHome
datetime value
Syntax
ph_fromunixtime ( al_unixtime, ai_utcoffset )
| Argument | Description |
| al_unixtime | Longlong. The Unix time to convert (a number
equal to the number of seconds past midnight Jan 1, 1970) |
| ai_utcoffset | Integer. The offset from UTC (Coordinated
Universal Time) in minutes to be applied to the
calculation (Unix time is stored as UTC) |
Return value
Datetime. Converts the Unix time
value in al_unixtime (applying the current timezone offset in ai_utcoffset) to a
PowerHome DateTime value.
Usage
Use this function to convert Unix time
values into DateTime values for use in other PowerHome functions
Examples
The following examples demonstrate typical syntax/usage for this function.
• ph_fromunixtime(1588887692, -300) -
Returns a DateTime value equivalent to 05/07/2020 16:41:32. The actual UTC Unix
time value is 05/07/2020 21:41:32 and the offset of -300 assumes being in
the Eastern US
timezone