Date & Time

CURRENT_TIME

PostgreSQL

Mengembalikan waktu saat ini (tanpa tanggal) dengan timezone. Nilai tetap sama selama satu transaksi.

Tipe hasil: time with time zone

Syntax

SQL

CURRENT_TIME
CURRENT_TIME(precision)

precisionintegeropsional

Jumlah digit presisi detik (0-6)

SQL

1 SELECT 
2   CURRENT_TIME,
3   CURRENT_TIME(0) AS no_fraction;

Mendapatkan waktu dengan dan tanpa fraction.

Hasil

current_time	no_fraction
14:30:45.123456+07	14:30:45+07

SQL

1 SELECT 
2   CASE 
3     WHEN CURRENT_TIME BETWEEN 09:00::time AND 17:00::time 
4     THEN Open
5     ELSE Closed
6   END AS status;

Mengecek apakah dalam jam operasional.

CURRENT_TIME

MySQL

CURRENT_TIME

Snowflake

CURRENT_TIME

BigQuery

CURRENT_TIME

DuckDB

1	SELECT
2	CASE
3	WHEN CURRENT_TIME BETWEEN 09:00::time AND 17:00::time
4	THEN Open
5	ELSE Closed
6	END AS status;