attempting to convert varchar to date in Impala

Question

Any suggestions on converting varchar (12/01/2020) to a date in Impala? Have tried using cast, converting to timestamp but continues to error or have null values. Thanks

question from:https://stackoverflow.com/questions/65850726/attempting-to-convert-varchar-to-date-in-impala

Answer 1

Pls use select to_timestamp('12/01/2020', 'MM/dd/yyyy');