Date & Time
DuckDB
DAYOFYEAR
DuckDBMengekstrak hari dalam tahun dari tanggal (1-366). Berguna untuk analisis seasonal dan time-series.
Tipe hasil:
INTEGERDiperbarui: 6 Jan 2026Syntax
SQL
DAYOFYEAR(date)Parameter
dateDATE/TIMESTAMPwajib
Tanggal yang akan diambil day of year-nya
Contoh Penggunaan
Mendapatkan Day of Year
SQL
1 SELECT 2 event_date, 3 DAYOFYEAR(event_date) as day_of_year 4 FROM ( 5 SELECT DATE '2024-01-01' as event_date UNION ALL 6 SELECT DATE '2024-06-15' UNION ALL 7 SELECT DATE '2024-12-31' 8 );
Melihat posisi hari dalam tahun.
Hasil
| event_date | day_of_year |
|---|---|
| 2024-01-01 | 1 |
| 2024-06-15 | 167 |
| 2024-12-31 | 366 |
Year-over-Year Comparison
SQL
1 SELECT 2 YEAR(sale_date) as year, 3 DAYOFYEAR(sale_date) as doy, 4 SUM(amount) as daily_sales 5 FROM sales 6 WHERE DAYOFYEAR(sale_date) <= 180 7 GROUP BY YEAR(sale_date), DAYOFYEAR(sale_date) 8 ORDER BY doy, year;
Membandingkan penjualan harian antar tahun berdasarkan day of year.
Hasil
| year | doy | daily_sales |
|---|---|---|
| 2023 | 1 | 5000000 |
| 2024 | 1 | 6500000 |
| 2023 | 2 | 4800000 |
| 2024 | 2 | 5200000 |
Progress Tahun
SQL
1 SELECT 2 TODAY() as current_date, 3 DAYOFYEAR(TODAY()) as current_doy, 4 ROUND(DAYOFYEAR(TODAY()) * 100.0 / 365, 1) as year_progress_pct;
Menghitung seberapa jauh kita dalam tahun ini.
Hasil
| current_date | current_doy | year_progress_pct |
|---|---|---|
| 2024-06-15 | 167 | 45.8 |