17,377
社区成员
发帖
与我相关
我的任务
分享oracle里如何计算两个时间之间的差值?
在sql server里这样的SQL语句:
delete from temps where datediff('n',logtime,now())>=5 and admin='123';
同等命令在ORACLE里该怎么写呢?
delete from temps where datediff('n',logtime,now())>=5 and admin='123';
同等命令在ORACLE里该怎么写呢?
...全文
请发表友善的回复…
发表回复
男人三十好累 2003-07-08
- 打赏
- 举报
round((logtime-sysdate)*1440)>=5
hammer_shi 2003-07-08
- 打赏
- 举报
ADD_MONTHS
CURRENT_DATE
CURRENT_TIMESTAMP
DBTIMEZONE
EXTRACT (datetime)
FROM_TZ
LAST_DAY
LOCALTIMESTAMP
MONTHS_BETWEEN
NEW_TIME
NEXT_DAY
NUMTODSINTERVAL
NUMTOYMINTERVAL
ROUND (date)
SESSIONTIMEZONE
SYS_EXTRACT_UTC
SYSTIMESTAMP
SYSDATE
TO_DSINTERVAL
TO_TIMESTAMP
TO_TIMESTAMP_TZ
TO_YMINTERVAL
TRUNC (date)
TZ_OFFSET
beckhambobo 2003-07-08
- 打赏
- 举报
(logtime-sysdate)*24*60>=5
