Date & Time
DuckDB
SECOND
DuckDBMengekstrak komponen detik dari timestamp. Mengembalikan angka 0-59.
Tipe hasil:
INTEGERDiperbarui: 6 Jan 2026Syntax
SQL
SECOND(timestamp)Parameter
timestampTIMESTAMP/TIMEwajib
Timestamp atau time yang akan diambil detiknya
Contoh Penggunaan
Mengambil Detik dari Timestamp
SQL
1 SELECT 2 event_time, 3 HOUR(event_time) as hour, 4 MINUTE(event_time) as minute, 5 SECOND(event_time) as second 6 FROM ( 7 SELECT TIMESTAMP '2024-06-15 14:30:45' as event_time UNION ALL 8 SELECT TIMESTAMP '2024-06-15 09:15:30' UNION ALL 9 SELECT TIMESTAMP '2024-06-15 23:59:59' 10 );
Mengekstrak komponen waktu lengkap.
Hasil
| event_time | hour | minute | second |
|---|---|---|---|
| 2024-06-15 14:30:45 | 14 | 30 | 45 |
| 2024-06-15 09:15:30 | 9 | 15 | 30 |
| 2024-06-15 23:59:59 | 23 | 59 | 59 |
Format Time String
SQL
1 SELECT 2 event_time, 3 LPAD(HOUR(event_time)::VARCHAR, 2, '0') || ':' || 4 LPAD(MINUTE(event_time)::VARCHAR, 2, '0') || ':' || 5 LPAD(SECOND(event_time)::VARCHAR, 2, '0') as formatted_time 6 FROM events;
Membuat string waktu dengan format HH:MM:SS.
Hasil
| event_time | formatted_time |
|---|---|
| 2024-06-15 09:05:03 | 09:05:03 |
| 2024-06-15 14:30:45 | 14:30:45 |
Konversi ke Total Seconds
SQL
1 SELECT 2 event_time, 3 HOUR(event_time) * 3600 + 4 MINUTE(event_time) * 60 + 5 SECOND(event_time) as seconds_since_midnight 6 FROM events;
Menghitung total detik sejak tengah malam.
Hasil
| event_time | seconds_since_midnight |
|---|---|
| 2024-06-15 00:00:00 | 0 |
| 2024-06-15 01:00:00 | 3600 |
| 2024-06-15 12:30:45 | 45045 |