ph_relativedtprecise PowerHome formula function
Description
Returns a datetime value relative to the passed offset and datetime value (either the output of a function eg, datetime() or a datetime 'literal' value such as
2010-12-15 12:30:00 ).
The returned time value will be to millisecond precision.
See the
Date / Time Functions section for detailed information concerning date / time formats.
Similar to the ph_relativedatetime() function but with greater time accuracy.
Syntax
ph_relativedtprecise ( dt, n )
| Argument |
Description |
|
dt
|
A datetime value which is the starting datetime.
|
|
n
|
A double value representing the number of seconds (partial seconds are in decimal format) in the future (positive values) or the past (negative values) that the new datetime should be offset from the starting datetime.
|
Return value
Datetime. Returns a new datetime value relative to the starting datetime with the time component to millisecond precision.
Examples
The following examples demonstrate typical syntax/usage for this function.
• ph_relativedtprecise(2015-01-15 00:00:00, 10.167)--> evaluates to: 12/15/2015 00:10:167
• ph_relativedtprecise(today(), 10.33) --> evaluates to: 01/15/2015 16:30:05:375