Oracle TO_DATE无法正常工作 [英] Oracle TO_DATE not working

问题描述

我有这个查询，它不返回任何行.但是，有些记录的日期大于90-JUN-90.为什么它不起作用?

I have this query which is not returning any rows. But there are records which are greater than 25-JUN-90 date. Why is it not working?

{SELECT employee_id, last_name,hire_date
   FROM employees WHERE hire_date > TO_DATE('25-JUN-90','dd-mon-yy');}

推荐答案

您要使用RR日期格式掩码将90更改为1990:

You want to use the RR date format mask to change 90 to 1990:

SELECT employee_id, last_name,hire_date
FROM employees WHERE hire_date > TO_DATE('25-JUN-90','dd-mon-RR');

这篇关于Oracle TO_DATE无法正常工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！