Created 09-12-2016 11:31 AM
@Mayank Pandey there are some ways of converting the date. For example something like select inp_dt, from_unixtime(unix_timestamp(substr(inp_dt,0,11),'dd-MMM-yyyy')) as todateformat from table;
There are several ways to attempt this if you do a google search on your needs.
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;
|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|