Fungsi SQL BigQuery

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.

Mengkonversi Unix timestamp (microseconds) ke TIMESTAMP.

Mengkonversi Unix timestamp (milliseconds) ke TIMESTAMP.

Mengkonversi Unix timestamp (seconds) ke TIMESTAMP.

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).

Converts a STRING or BYTES value into an array of code points (Unicode code points for STRING, values 0-255 for BYTES).

Converts a BigQuery value to the native JSON type.

Converts a BigQuery value to a JSON string representation.

Replaces each character from the source character set with the corresponding character in the target character set. Character-level translation.

Removes characters from the beginning and end of a string. By default, removes whitespace.

Truncates a number to the specified precision without rounding (truncation toward zero).

Mengkonversi DATE ke jumlah hari sejak 1970-01-01.

Mengkonversi TIMESTAMP ke Unix timestamp dalam mikrodetik.

Mengkonversi TIMESTAMP ke Unix timestamp dalam milidetik.

Mengkonversi TIMESTAMP ke Unix timestamp dalam detik.

Mengubah array menjadi set of rows (flatten array).