I am trying to load data from excel source where the date column has data like "Sun Mar 07 00:17:07 PST 2021" and I need to load it to SQL table with date time data type and my value supposed to be in following format mm/dd/yyyy hh:mm:ss. Please let me know the solution.
Excel Source Data:
Sun Mar 07 00:17:07 PST 2021
SQL Destination Table with datetime column: