Date & Time

TO_CHAR

PostgreSQL

Mengkonversi tanggal, timestamp, atau angka ke string dengan format tertentu. Sangat fleksibel untuk formatting output.

Tipe hasil: text

Syntax

SQL

TO_CHAR(timestamp, format)
TO_CHAR(number, format)

timestamp/numbertimestamp/numericwajib

Nilai yang akan diformat

formattextwajib

Pattern format (YYYY, MM, DD, HH24, MI, SS, dll)

SQL

1 SELECT 
2   TO_CHAR(CURRENT_TIMESTAMP, DD-MM-YYYY) AS tanggal,
3   TO_CHAR(CURRENT_TIMESTAMP, DD Month YYYY) AS tanggal_lengkap;

Format tanggal gaya Indonesia.

Hasil

tanggal	tanggal_lengkap
15-01-2024	15 January 2024

SQL

1 SELECT 
2   TO_CHAR(CURRENT_TIMESTAMP, YYYY-MM-DD HH24:MI:SS) AS iso_format,
3   TO_CHAR(CURRENT_TIMESTAMP, HH12:MI AM) AS time_12h;

Format ISO dan 12-hour time.

Hasil

iso_format	time_12h
2024-01-15 14:30:45	02:30 PM

SQL

1 SELECT 
2   TO_CHAR(1234567.89, 999,999,999.99) AS formatted_number,
3   TO_CHAR(1234567.89, Rp999G999G999D99) AS rupiah;

Format angka dengan separator.

Hasil

formatted_number	rupiah
1,234,567.89	Rp 1.234.567,89

DATE_FORMAT

MySQL

TO_CHAR

Snowflake

STRFTIME

DuckDB

1	SELECT
2	TO_CHAR(CURRENT_TIMESTAMP, DD-MM-YYYY) AS tanggal,
3	TO_CHAR(CURRENT_TIMESTAMP, DD Month YYYY) AS tanggal_lengkap;

1	SELECT
2	TO_CHAR(CURRENT_TIMESTAMP, YYYY-MM-DD HH24:MI:SS) AS iso_format,
3	TO_CHAR(CURRENT_TIMESTAMP, HH12:MI AM) AS time_12h;