解決

amazon web services - AWS Athena and date_format - Stack Overflow

select  current_timestamp
       ,date_format     (current_timestamp, '%Y_%m_%d')
       ,format_datetime (current_timestamp, 'y_M_d')