Fungsi SQL BigQuery

Returns the position (1-based) of the substring that matches the regular expression. Returns 0 if there is no match.

Replaces all substrings that match the regular expression with a replacement string. Supports backreferences.

Alias for REGEXP_EXTRACT. Extracts the substring that matches the regular expression.

Repeats a string n times. Useful for generating patterns.

Replaces all occurrences of a substring with a new string. Replacement is case-sensitive.

Reverses the order of characters in a string. The first character becomes the last and vice versa.

Extracts a specified number of characters from the right (end) of a string. A more readable shorthand for extracting trailing characters.

Rounds a number to the specified decimal precision using the half-away-from-zero rounding method.

Assigns a unique sequential number to each row within a partition, starting at 1. No duplicate values are assigned.

Pads the right side of a string with characters until it reaches a specified length. Right padding.

Removes characters from the right side (end) of a string. Right trim for trailing characters.

Melakukan penjumlahan aman yang mengembalikan NULL jika overflow.

Mengkonversi expression ke tipe data yang ditentukan, mengembalikan NULL jika gagal.

Safely converts a BYTES value to a STRING, replacing any invalid UTF-8 characters with the Unicode replacement character instead of raising an error.

Performs safe division that returns NULL instead of an error when the divisor is zero.

Melakukan perkalian aman yang mengembalikan NULL jika terjadi overflow.

Mengembalikan negasi (nilai negatif) secara aman, NULL jika overflow.

Mengakses elemen array dengan zero-based index, mengembalikan NULL jika out of bounds.

Mengakses elemen array dengan one-based index, mengembalikan NULL jika out of bounds.

Melakukan pengurangan aman yang mengembalikan NULL jika overflow.

Mengembalikan email address dari user yang menjalankan query.

Menghitung SHA-1 hash dari input. Return BYTES.

Menghitung SHA-256 hash dari input. Aman untuk kriptografi.

Menghitung SHA-512 hash dari input. Hash paling kuat di keluarga SHA-2.