TO_CHAR

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;

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