@njayakumar the solution provided by you has worked. Thank a ton 🙂 ... View more

@Ian Roberts the above query gave the todateformat output as NULL. ... View more

Hi @Ian Roberts, I tried the following query which you have suggested but I'm getting very different and weird date. Select log_source_time, from_unixtime(unix_timestamp((test_date),'mm/dd/yyyy hh:mm:ss a'),'yyyy-mm-dd hh:mm:ss a') as todateformat from table1 limit 2; log_source_time todateformat 9/1/2016 11:31:21 AM 2016-31-01 11:31:21 AM 9/2/2016 9:59:59 AM 2016-59-02 09:59:59 AM ... View more