MINUTE_NOW
Description
The MINUTE_NOW function returns the minute of the current time of the app-server in the specified time zone.
The time zone can be specified with a time zone id, like UTC
, GMT+01
or Europe/Berlin
. If no time zone is specified the time zone of the app-server is used.
Syntax
MINUTE_NOW ( [time_zone_id] )
The <time_zone_id>
parameter identifies the time zone as described here.
Operator Performance
As the result of MINUTE_NOW
has to be recalculated every time the filter changes, using MINUTE_NOW
excessively can have a negative impact on query performance. We therefore recommend to only use the function where necessary.
Examples
[1] Get the minute of the current time on the app-server: | ||||||
| ||||||
|
[2] Get the minute of the current time in UTC: | ||||||
| ||||||
|
[3] Get the minute of the current time in GMT+1: | ||||||
| ||||||
|
[4] Get the minute of the current time in time zone | ||||||
| ||||||
|