Date & Time

DATE

MySQL

Mengekstrak bagian tanggal dari datetime atau timestamp. Menghapus komponen waktu.

Tipe hasil: DATEDiperbarui: 7 Jan 2026

Syntax

SQL

DATE(expr)

exprdatetimewajib

Ekspresi datetime atau timestamp

SQL

1 SELECT DATE('2024-01-15 14:30:45') AS date_only;

Mengambil bagian tanggal saja.

Hasil

date_only: 2024-01-15

SQL

1 SELECT DATE(created_at) AS order_date,
2        COUNT(*) AS order_count
3 FROM orders
4 GROUP BY DATE(created_at);

Menghitung order per tanggal.

Hasil

order_date: 2024-01-15, order_count: 50

SQL

1 SELECT * FROM logs
2 WHERE DATE(timestamp) = '2024-01-15';

Mencari log pada tanggal tertentu.

Hasil

(logs on that date)

1	SELECT DATE(created_at) AS order_date,
2	COUNT(*) AS order_count
3	FROM orders
4	GROUP BY DATE(created_at);