Oracle如何查看时间格式？

Question

select * from sal_order
where sale_date between to_date('2021-07-12 00:00:00','yyyy-mm-dd hh24:mi:ss') and to_date('2021-07-14 23:00:00','yyyy-mm-dd hh24:mi:ss')
order by sale_date desc
这个出现格式与字符串不符的报错信息
sale_date这个字段是储存在varchar类型里面的

Answer 1

去掉格式转换试下

select *
  from sal_order
 where sale_date between '2021-07-12 00:00:00' and '2021-07-14 23:00:00'
 order by sale_date desc