search

Home >Database >Mysql Tutorial >Oracle 数据库日期比较

Oracle 数据库日期比较

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-07 17:09:161110browse

今天碰到一个问题： DATE 类型 08-11月-09 12.00.00.000000 上午 保存格式如上所述 select * from TBL_FLIGHT t where to_date(s

今天碰到一个问题：

DATE 类型

08-11月-09 12.00.00.000000 上午

保存格式如上所述

select * from TBL_FLIGHT t where to_date(substr(t.FLIGHT_DATE,1,10),'dd-mon-yy')>=to_date('2011-9-1','yyyy-mm-dd')

and to_date(substr(t.FLIGHT_DATE,1,10),'dd-mon-yy')

这样子就好了。

linux

，
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：解决内存设置过大导致实例无法启动ORA-27100Next article：CentOS 5上升级Oracle到10.2.0.4时,检测操作系统失败的解决方法

Related articles

See more