Filter berdasarkan kategori:
Menampilkan 24 dari 220 fungsi
DATE
Creates a DATE value from individual components, or extracts a DATE from a timestamp or datetime expression.
DATEDATETIME
Creates a DATETIME value from components, combines a DATE and TIME, or converts from a TIMESTAMP.
DATETIMEDATETIME_ADD
Adds a time interval to a DATETIME value. Supports all units from MICROSECOND to YEAR.
DATETIMEDATETIME_DIFF
Calculates the difference between two DATETIME values in the specified unit.
INT64DATETIME_SUB
Subtracts a time interval from a DATETIME value. The inverse of DATETIME_ADD.
DATETIMEDATETIME_TRUNC
Truncates a DATETIME value to the specified granularity. Supports all date parts from MICROSECOND through YEAR.
DATETIMEDATE_ADD
Adds a specified time interval to a DATE. Returns a new DATE.
DATEDATE_DIFF
Calculates the difference between two DATE values in the specified unit. Returns an integer value.
INT64DATE_FROM_UNIX_DATE
Mengkonversi jumlah hari sejak 1970-01-01 ke DATE.
DATEDATE_SUB
Subtracts a specified time interval from a DATE. Returns a new DATE.
DATEDATE_TRUNC
Truncates a DATE to the specified granularity (DAY, WEEK, MONTH, QUARTER, YEAR).
DATEDEGREES
Mengkonversi sudut dari radian ke derajat.
FLOAT64DENSE_RANK
Memberikan peringkat untuk setiap baris tanpa gap. Baris dengan nilai sama mendapat peringkat sama, peringkat berikutnya langsung +1.
INT64DIV
Performs integer division (floor division), discarding the remainder.
INT64 or NUMERICENDS_WITH
Checks whether a string ends with a specified suffix. Returns a boolean.
BOOLEXP
Calculates e raised to the power of the expression (e^x), where e ≈ 2.71828.
FLOAT64EXTRACT
Extracts a specific component from a DATE, TIME, DATETIME, or TIMESTAMP value. Returns an integer.
INT64FARM_FINGERPRINT
Menghitung fingerprint menggunakan algoritma FarmHash. Sangat cepat dan cocok untuk BigQuery.
INT64FIRST_VALUE
Returns the first value in the window frame for each row.
Same as input expressionFLOOR
Rounds a number down to the nearest integer less than or equal to the input.
Same as input typeFORMAT
Formats values into a string based on a format string (similar to printf). Supports a wide range of format specifiers.
STRINGFORMAT_DATE
Formats a DATE value into a string based on the specified format. Uses standard format elements.
STRINGFORMAT_DATETIME
Formats a DATETIME value into a string. Combines format elements for both date and time.
STRINGFORMAT_TIME
Formats a TIME value into a string based on the specified format.
STRING