Fungsi Date & Time 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.

Converts a string to a TIMESTAMP type with timezone support.

Creates a TIME value from components, or extracts the TIME portion from a timestamp or datetime.

Creates a TIMESTAMP value from a string, DATE, or DATETIME. TIMESTAMP values are always stored in UTC.

Adds a time interval to a TIMESTAMP value. The result remains in UTC.

Calculates the difference between two TIMESTAMP values in the specified unit. Most accurate for measuring absolute durations.

Subtracts a time interval from a TIMESTAMP value. The inverse of TIMESTAMP_ADD.

Truncates a TIMESTAMP to the specified granularity. Supports timezone for accurate local-time results.

Adds a time interval to a TIME value. Useful for work-hour calculations and scheduling.

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

Subtracts a time interval from a TIME value. The inverse of TIME_ADD.

Truncates a TIME value to the specified granularity (MICROSECOND, MILLISECOND, SECOND, MINUTE, HOUR).