Fungsi SQL BigQuery

Subtracts a time interval from a DATETIME value. The inverse of DATETIME_ADD.

Truncates a DATETIME value to the specified granularity. Supports all date parts from MICROSECOND through YEAR.

Adds a specified time interval to a DATE. Returns a new DATE.

Calculates the difference between two DATE values in the specified unit. Returns an integer value.

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

Subtracts a specified time interval from a DATE. Returns a new DATE.

Truncates a DATE to the specified granularity (DAY, WEEK, MONTH, QUARTER, YEAR).

Mengkonversi sudut dari radian ke derajat.

Memberikan peringkat untuk setiap baris tanpa gap. Baris dengan nilai sama mendapat peringkat sama, peringkat berikutnya langsung +1.

Performs integer division (floor division), discarding the remainder.

Checks whether a string ends with a specified suffix. Returns a boolean.

Calculates e raised to the power of the expression (e^x), where e ≈ 2.71828.

Extracts a specific component from a DATE, TIME, DATETIME, or TIMESTAMP value. Returns an integer.

Menghitung fingerprint menggunakan algoritma FarmHash. Sangat cepat dan cocok untuk BigQuery.

Returns the first value in the window frame for each row.

Rounds a number down to the nearest integer less than or equal to the input.

Formats values into a string based on a format string (similar to printf). Supports a wide range of format specifiers.

Formats a DATE value into a string based on the specified format. Uses standard format elements.

Formats a DATETIME value into a string. Combines format elements for both date and time.

Formats a TIME value into a string based on the specified format.