Fungsi SQL BigQuery

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