Date & Time

DATETIME

BigQueryBigQuery

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

Tipe hasil: DATETIMEDiperbarui: 13 Jun 2026

Syntax

SQL
DATETIME(year, month, day, hour, minute, second) | DATETIME(date [, time]) | DATETIME(timestamp [, time_zone])

Parameter

yearINT64opsional

Year

monthINT64opsional

Month (1-12)

dayINT64opsional

Day

hourINT64opsional

Hour (0-23)

minuteINT64opsional

Minute (0-59)

secondINT64opsional

Second (0-59)

dateDATEopsional

Date component

timeTIMEopsional

Time component (defaults to 00:00:00)

timestampTIMESTAMPopsional

Timestamp to convert

time_zoneSTRINGopsional

Timezone for timestamp conversion

Contoh Penggunaan

Create from Components

SQL
1SELECT
2  DATETIME(2024, 1, 15, 14, 30, 0) as dt;

Create a DATETIME from individual year, month, day, hour, minute, and second components.

Hasil
2024-01-15T14:30:00

Combine Date and Time

SQL
1SELECT
2  DATETIME(DATE '2024-01-15', TIME '14:30:00') as combined,
3  DATETIME(DATE '2024-01-15') as date_only;

Combine a DATE and TIME value into a single DATETIME.

Hasil
combineddate_only
2024-01-15T14:30:002024-01-15T00:00:00

Convert from Timestamp

SQL
1SELECT
2  ts,
3  DATETIME(ts) as dt_utc,
4  DATETIME(ts, 'Asia/Jakarta') as dt_jakarta
5FROM UNNEST([TIMESTAMP '2024-01-15 10:00:00 UTC']) as ts;

Convert a TIMESTAMP to DATETIME with timezone adjustment.

Hasil
tsdt_utcdt_jakarta
2024-01-15 10:00:00 UTC2024-01-15T10:00:002024-01-15T17:00:00

Pertanyaan Umum tentang DATETIME

Apa itu fungsi DATETIME di BigQuery?
Creates a DATETIME value from components, combines a DATE and TIME, or converts from a TIMESTAMP. Di BigQuery, fungsi DATETIME termasuk dalam kelompok fungsi yang sering digunakan untuk mengolah dan menganalisis data secara efisien.
Bagaimana cara menggunakan DATETIME di BigQuery?
Gunakan sintaks berikut: DATETIME(year, month, day, hour, minute, second) | DATETIME(date [, time]) | DATETIME(timestamp [, time_zone]). Pastikan argumen yang dimasukkan sudah sesuai dengan tipe data yang diharapkan.
Apa nilai yang dikembalikan oleh fungsi DATETIME?
Fungsi DATETIME mengembalikan nilai bertipe DATETIME. Pastikan tipe data hasil sudah sesuai dengan kebutuhan query atau formula kamu. Jika input mengandung nilai NULL, perilaku fungsi dapat berbeda — selalu periksa dokumentasi untuk memastikan hasilnya sesuai ekspektasi.
Apa saja parameter fungsi DATETIME?
Semua 10 parameter bersifat opsional. Parameter yang digunakan: year (INT64, opsional): Year; month (INT64, opsional): Month (1-12); day (INT64, opsional): Day; hour (INT64, opsional): Hour (0-23); minute (INT64, opsional): Minute (0-59); second (INT64, opsional): Second (0-59); date (DATE, opsional): Date component; time (TIME, opsional): Time component (defaults to 00:00:00); timestamp (TIMESTAMP, opsional): Timestamp to convert; time_zone (STRING, opsional): Timezone for timestamp conversion.
Ngulik Langsung

Sudah paham DATETIME? Latih langsung di browser

Latihan interaktif, langsung di browser.

Latihan Langsung →
Kembali ke BigQuery Functions