Fungsi SQL BigQuery

Converts a string to a TIMESTAMP type with timezone support.

Creates a TIME value from components, or extracts the TIME portion from a timestamp or datetime.

Creates a TIMESTAMP value from a string, DATE, or DATETIME. TIMESTAMP values are always stored in UTC.

Adds a time interval to a TIMESTAMP value. The result remains in UTC.

Calculates the difference between two TIMESTAMP values in the specified unit. Most accurate for measuring absolute durations.

Subtracts a time interval from a TIMESTAMP value. The inverse of TIMESTAMP_ADD.

Truncates a TIMESTAMP to the specified granularity. Supports timezone for accurate local-time results.

Adds a time interval to a TIME value. Useful for work-hour calculations and scheduling.

Calculates the difference between two TIME values in the specified unit.

Subtracts a time interval from a TIME value. The inverse of TIME_ADD.

Truncates a TIME value to the specified granularity (MICROSECOND, MILLISECOND, SECOND, MINUTE, HOUR).