date formathttp://www.orafaq.com/forum/./mv/msg/188300/588501/#msg_588501
I want to do 'ORDER BY' by concatenating the two columns(date +varchar2).But not working and geting the error - ORA-01855: AM/A.M. or PM/P.M. required
. Please check below and provide solution also .

]]>Littlefoot2013-06-26T10:59:51-00:00Re: date formathttp://www.orafaq.com/forum/./mv/msg/188300/588528/#msg_588528
Can you please explain how the below line will work in above query]]>prejib2013-06-26T11:31:08-00:00Re: date formathttp://www.orafaq.com/forum/./mv/msg/188300/588531/#msg_588531
case when substr (am_pm, -2) = 'AM' then 0 else 1/2 end]]>prejib2013-06-26T11:38:59-00:00Re: date formathttp://www.orafaq.com/forum/./mv/msg/188300/588534/#msg_588534
cookiemonster2013-06-26T11:46:31-00:00Re: date formathttp://www.orafaq.com/forum/./mv/msg/188300/588535/#msg_588535
I used it to switch all times to HH24 format (i.e. no AM/PM).]]>Littlefoot2013-06-26T11:46:58-00:00Re: date formathttp://www.orafaq.com/forum/./mv/msg/188300/588545/#msg_588545
One scenario is failing with this query 12:30 Am will be converted as 12:30PM and vice-versa as given below. Can you please check?

]]>prejib2013-06-26T12:34:04-00:00Re: date formathttp://www.orafaq.com/forum/./mv/msg/188300/588546/#msg_588546
The correct solution here is to fix it so that am_pm is in a consistent format, or better yet get rid of the column entirely.
If it's not in a consistent format then bugs will be unavoidable.]]>cookiemonster2013-06-26T12:47:33-00:00Re: date formathttp://www.orafaq.com/forum/./mv/msg/188300/588547/#msg_588547