Fungsi SQL 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.