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] )
Time zone identifiers
The IANA Time Zone Database supports many different time zone names. Using Germany as an example, the time zone CET is the standard time zone and CEST is the daylight saving time zone. By using the uniform naming convention in the database, any daylight saving time will automatically be respected by MINUTE_NOW if the given country or area is currently in daylight saving time.
The uniform naming convention is structured as <area>/<location> which will represent a country or major area, for Germany that would be Europe/Berlin.
An error will be returned if the given <time_zone_id> is invalid or ambiguous.
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 | ||||||
| ||||||
|