How to Add the AD/BC Indicator to a Date in Oracle

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.

Continue reading

How to Add the Meridiem Indicator (AM/PM) to a Time Value in Oracle

When using the TO_CHAR() function to format a datetime value in Oracle Database, you can add the meridiem indicator (AM/PM) by simply adding either AM or PM to your format model.

Oracle then displays the appropriate meridiem indicator, depending on whether the time value is AM or PM.

You can provide it in any uppercase or lowercase, and with or without dots (e.g. AM, A.M. am, a.m, etc). Oracle will then display the meridiem indicator as specified.

Continue reading