Data deploy | date format

rohitspathak123

Hi,

I want to specify date in following format (MM/dd/yyyy HH:mm AM/PM)

MM/dd/yyyy HH:mm is working fine in dd config and database is getting populated too. Also if we give HH:mm in 24 hours format like 23:10, when its gets populated into DB it gets converted into PM automatically (which is good).


But now the problem is that user now wants to enter date in the format of AM/PM . When I change DD config for this date formate as:
MM/dd/yyyy HH:mm AM

its giving followinng error in dd logs
DBD: db-datetime-format is not specified for [WEPN_EFF_START_DATE]. Using default converter.
DBD: Converted JDK DateFormat [MM/dd/yyyy HH:mm AM] to Oracle DateFormat [MM/DD/YYYY HH24:MI AMM].
DBD: db-datetime-format is not specified for [WEPN_EFF_STOP_DATE]. Using default converter.
DBD: Converted JDK DateFormat [MM/dd/yyyy] to Oracle DateFormat [MM/DD/YYYY].
DBD: SELECTELECT WEPN_NEWS_LINK_LABEL,WEPN_NEWS_LINK_URL,WEPn_VIDEO_DURATION,WEPN_ALL_TERRITORIES_FLAG,WEPN_GENERIC_TERRITORY_FLAG,TO_CHAR(WEPN_EFF_START_DATE,'MM/DD/YYYY HH24:MI AMM')

Please help

Vishakha

We are using the below code for handling AM/PM which works well.
Note the data-format="MM/dd/yyyy hh:mm:ss a" for the AM date.



Try it ...