Date & Time
BigQuery
DATETIME
BigQueryCreates a DATETIME value from components, combines a DATE and TIME, or converts from a TIMESTAMP.
Tipe hasil:
DATETIMEDiperbarui: 13 Jun 2026Syntax
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
1 SELECT 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
1 SELECT 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
| combined | date_only |
|---|---|
| 2024-01-15T14:30:00 | 2024-01-15T00:00:00 |
Convert from Timestamp
SQL
1 SELECT 2 ts, 3 DATETIME(ts) as dt_utc, 4 DATETIME(ts, 'Asia/Jakarta') as dt_jakarta 5 FROM UNNEST([TIMESTAMP '2024-01-15 10:00:00 UTC']) as ts;
Convert a TIMESTAMP to DATETIME with timezone adjustment.
Hasil
| ts | dt_utc | dt_jakarta |
|---|---|---|
| 2024-01-15 10:00:00 UTC | 2024-01-15T10:00:00 | 2024-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.
Ngulik Langsung
Latihan Langsung →Sudah paham DATETIME? Latih langsung di browser
Latihan interaktif, langsung di browser.