I am trying to do the following:
sel cast ('20141121 083906 PM' as TIMESTAMP(6) format 'YYYYMMDDBHHMISSBT').
This is working fine for non zero Hours. However, for hour like 00 the above query is throwing invalid timestamp error.
Any idea why?