When using the TO_CHAR()
function to format a datetime value in Oracle Database, you can add the AD/BC indicator by simply adding either AD
or BC
to your format model.
Oracle then displays the appropriate indicator, depending on whether the date value is AD or BC.
You can provide it in any uppercase or lowercase, and with or without dots (e.g. AD
, A.D.
ad
, a.d
, etc). Oracle will then display the indicator as specified.