d4 BETWEEN to_date('1999-12-12','yyyy/mm/dd') and to_date('2000-12-12','yyyy/mm/dd')
SQL> select 1 from dual where sysdate between '2002-10-01' and '2002-12-01'; 1 --------- 1
使用to_date()来转换是肯定没问题的
d4是长日期或短日期都可以用 d4 BETWEEN to_date('1999-12-12','yyyy/mm/dd') and to_date('2000-12-12','yyyy/mm/dd')但有时间最好这样d4 BETWEEN to_date('1999-12-12','yyyy/mm/dd') and (to_date('2000-12-12','yyyy/mm/dd')+1)
---------
1
使用to_date()来转换是肯定没问题的
d4 BETWEEN to_date('1999-12-12','yyyy/mm/dd') and to_date('2000-12-12','yyyy/mm/dd')但有时间最好这样d4 BETWEEN to_date('1999-12-12','yyyy/mm/dd') and (to_date('2000-12-12','yyyy/mm/dd')+1)
d4<to_date('1999-12-12','yyyy-mm-dd');
d4<to_date('12-12-1999','mm-dd-yyyy');
d4<to_date('12-12-1999','dd-mm-yyyy');
d4<to_date('12/12/1999','mm/dd/yyyy');
等等,肯定还有。我总结日期格式的表示与系统的区域设置无关。上面各位,看看你们的分数吧,哈哈,谢谢。