date - 雅典娜日期格式无法将字符串转换为日期格式

Question

尝试了以下语法，他们都没有帮助将字符串类型列转换为日期

select INVC_,APIDT,APDDT from APAPP100 limit 10
select current_date, APIDT,APDDT from APAPP100 limit 10
select date_format( b.APIDT, '%Y-%m-%d') from APAPP100 b
select CAST( b.APIDT AS date) from APAPP100 b
select date(b.APIDT) from APAPP100 b
select convert(datetime, b.APIDT) from APAPP100 b
select date_parse(b.APIDT, '%Y-%m-%d') from APAPP100 b
select str_to_date(b.APIDT) from APAPP100 b

Answer 1

将字符串解析为日期的正确查询是 date_parse .

这将导致以下查询:

select date_parse(b.APIDT, '%Y-%m-%d') from APAPP100 b

prestodb 文档:
6.10. Date and Time Functions and Operators