Format Tanggal Indonesia di SELECT Oracle

Sintaks:
TO_CHAR(fieldTanggal,'FMDay, DD Month YYYY','NLS_DATE_LANGUAGE =
INDONESIAN') AS namaFieldAlias

Contoh:
TO_CHAR(tbrtacarakulyo1.DTGL,'FMDay, DD Month YYYY','NLS_DATE_LANGUAGE =
INDONESIAN') AS tgl

Hasil:
Kamis, 19 Juni 1985


Komentar