SELECT EXTRACT (DAY FROM (END_DATE-BEG_DATE))*24*60+
EXTRACT (HOUR FROM (END_DATE-BEG_DATE))*60+
EXTRACT (MINUTE FROM (END_DATE-BEG_DATE))
from foo
EXTRACT (HOUR FROM (END_DATE-BEG_DATE))*60+
EXTRACT (MINUTE FROM (END_DATE-BEG_DATE))
from foo
解决方案 »
- select查询中带中文参数的问题
- java 调用oracle sqlldr命令只能导入832行问题
- sys_refcursor的问题
- 哥們 幫個忙 好嗎?
- ORA-01034 ORACLE not available如何解决?
- 论者有分 ,欢迎大家讨论, Oracle8i 与 Oracle9i 之间数据的通信 ,移植 , 导入导出等等还有其他兼容性问题 ?
- 安装Statspack的问题??
- 为什么我的oracle8中的sql*plus里面不能运行sqlldr?
- oracle连接问题,急急急急急!!!!!!!!!!!!!!!!
- 用dblink同步数据时发现数据重复
- SQL语句查询
- 如何用纯SQL语句实现几个字段的拼接
The TIMESTAMP data type is an extension of the DATE data type. It stores fractional seconds in addition to the information stored in the DATE data type. The TIMESTAMP data type is useful for storing precise time values, such as in applications that must track event order.~ timestamp 数据类型是DATE类型的一种扩展,它更加精确~ 依赖于平台,能够提供 毫秒或者微秒级的精度.