sql i am using   select cast(from_unixtime(unix_timestamp(date_with_am,'MM-dd-yyyy HH:mm a'), 'yyyy-dd-MM HH:mm:ss')) date_with_am, Employee_Name as employee_name, Email as email, cast(from_unixtime(unix_timestamp(term_date,'MM-dd-yyyy'), 'yyyy-dd-MM HH:mm:ss'))  as term_date,  from table; ... View more