Date & Time

CURTIME

MySQL

Mengembalikan waktu saat ini tanpa tanggal. Alias: CURRENT_TIME.

Tipe hasil: TIMEDiperbarui: 7 Jan 2026

Syntax

SQL

CURTIME([fsp])

fspintegeropsional

Fractional seconds precision (0-6)

Default: 0

SQL

1 SELECT CURTIME() AS current_time;

Mendapatkan waktu saat ini.

Hasil

current_time: 14:30:45

SQL

1 SELECT CURTIME(3) AS precise_time;

Waktu dengan milidetik.

Hasil

precise_time: 14:30:45.123

SQL

1 SELECT 
2   CASE WHEN CURTIME() BETWEEN '09:00:00' AND '17:00:00'
3        THEN 'Working Hours' ELSE 'Off Hours' END AS status;

Mengecek apakah dalam jam kerja.

Hasil

status: Working Hours

1	SELECT
2	CASE WHEN CURTIME() BETWEEN '09:00:00' AND '17:00:00'
3	THEN 'Working Hours' ELSE 'Off Hours' END AS status;