The column name is ORD_MGMT_IP_DT and it is of Date format for example in my case it is 3/12/2010 9:27:11 PM in the db.
I need to fetch the date time and the AM/PM in the format dd/MM/yyyy hh:mm:ss a I tried fetching it by writing it as to_char(rep_ord_trkg.ord_mgmt_ip_dt,'dd/MM/yyyy hh:mm:ss a') AS OrderDate in Java.
But am not getting the values on the page instead, I'm getting an Error 500 on page. When i tried without the 'a' i.e for the AM/PM i got the value in the page but the time was incorrect, like 12/3/2010 9:03:11. I'm quite confused that, how this is failing to fetch me the correct values when given with 'a' and it is throwing exceptions when given with 'a'.
Kindly help me out on this ranchers. Thanks a ton in advance.Awaiting your replies.