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