Fungsi SQL BigQuery

Returns the current date based on the specified timezone or the default timezone.

Returns the current datetime (date and time without timezone information) based on the specified timezone.

Returns the current time (without a date) based on the specified timezone.

Returns the current timestamp in UTC. This is the most common way to get the current date and time in BigQuery.

Creates a DATE value from individual components, or extracts a DATE from a timestamp or datetime expression.

Creates a DATETIME value from components, combines a DATE and TIME, or converts from a TIMESTAMP.

Adds a time interval to a DATETIME value. Supports all units from MICROSECOND to YEAR.

Calculates the difference between two DATETIME values in the specified unit.

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.

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

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

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

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.

Formats a TIMESTAMP value into a string. Supports timezone for accurate display.

Returns the last day of the specified period (month, quarter, or year).

Membuat DATE dari komponen year, month, dan day.

Parses a string into a DATE based on the specified format. The inverse of FORMAT_DATE.

Converts a string into a DATETIME type based on the specified format.

Converts a time string into a TIME type based on the specified format.