Details
-
Sub-task
-
Status: Closed
-
Major
-
Resolution: Duplicate
-
None
-
None
-
None
-
None
Description
Add support for BigQuery's TIME() function. The function constructs a TIME expression from the provided arguments.
There are three ways the function can be called:
1. TIME(HOUR, MINUTE, SECOND)
2. TIME(TIMESTAMP [, TIMEZONE]) (Calcite does not currently support timestamp with time zone.
3. TIME(DATETIME) (Calcite does not currently support DATETIME)
Examples:
TIME(5, 30, 50) would return '05:30:50'.
TIME(TIMESTAMP '2008-12-25 15:30:00') would return '15:30:00'.