使用 "split "和连接。

with your_data as (
select  '06/23/2020 07:57:45' as str
)

select concat_ws('-',splitted[0],splitted[1],splitted[2]) as Result
from
(
select split(str,'[/ ]') as splitted
  from your_data
)s

结果。

06-23-2020

使用from_unixtime(unix_timestamp(string, format_from), format_to) 。

select from_unixtime(unix_timestamp(str,'MM/dd/yyyy HH:mm:ss'),'MM-dd-yyyy') as Result
  from your_data

结果。

06-23-2020