Description
The
timestamp_diff()
function returns the difference
between two timestamp objects. The units used to express the difference is identified
by the
part
parameter. The second timestamp is subtracted
from the first timestamp. If the first timestamp is greater than the second, a negative value
is returned. If the result of this function is between 0 and 1, 0 is returned.
dataset = xdr_data
| filter story_publish_timestamp != null
| alter ts = to_timestamp(story_publish_timestamp, "MILLIS")
| alter ct = current_time()
| alter diff = timestamp_diff(ct, ts, "MINUTE")
| fields ts, ct, diff
| limit 1