ON THIS PAGE:
Format
Time()
Returns
Returns the timestamp of each sample point, expressed in seconds since the 1st of January 1970, UTC.
When to Use
This can be useful when you call date-time functions and you want the date arithmetic to be done at that time.
You can use this function as a parameter for any function that accepts a DateTime parameter.
E.g. If your start time is 9am and your end time is 11am and you have a 30 minute sample interval, then it will return:
| Timestamp | Value | Confidence |
| 9:00 | 9:00 | 100 |
| 9:30 | 9:30 | 100 |
| 10:00 | 10:00 | 100 |
| 10:30 | 10:30 | 100 |
| 11:00 | 11:00 | 100 |
You can then use these as input values to other functions, such as the sampled ones.
Examples
Expression: CalendarDayStart(Time())
Result: Returns the start of the day in the configured calendar time zone.
Expression: CalendarDayStart(Time(), ProductionTimeZone())
Result: Returns the start of the day in the configured production time zone.
Expression: CalendarDayStart(Time(), "Australia/Perth")
Result: Returns the start of the day in Perth’s time zone.