由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - Oracle 里面怎么计算date difference?
相关主题
Oracle8概 述从Technet那里拿的Oracle光盘版本有什么限制?
求职Oracle DBA请教oracle8如何用
how to do a case insensitive comparisonoracle和XML
[转载] 问个SQL问题[转载] what's the equivalent of 'minus' (oracle) in access?
问个初级问题.不要笑话Oracle 8i for Linux
Late afternoon 腦不好使Oracle Lite 4.0 on 95
也問 Common Table Expression 问题Is that possible for Applet to access the Oracle?
Re: Web Databasewant help on RDBMS
相关话题的讨论汇总
话题: date话题: blah话题: select话题: oracle话题: where
进入Database版参与讨论
1 (共1页)
z*********8
发帖数: 2070
1
比如我有两个sql expression各自返回一个date
1. exp1
select date_1
from table_1
where blah blah
2. exp2
Select date_2
from table_2
where blah blah
那么该怎么计算这两个date之间的差值并用小时表现出来呢? 简单的 exp1-exp2 可行
不?
t*********i
发帖数: 217
2
googled
search 'Returns The Number Of Seconds Between Two Date-Time Values' on page
http://www.psoug.org/reference/date_func.html
it works
o******5
发帖数: 29
3
select (a.date_1-b.date_2)/24
from
(select date_1
from table_1
where blah blah) a,
(Select date_2
from table_2
where blah blah) b
where a.col1=b.col1
1 (共1页)
进入Database版参与讨论
相关主题
want help on RDBMS问个初级问题.不要笑话
A questionLate afternoon 腦不好使
Where can I download Oracle for Linux?也問 Common Table Expression 问题
A question about OracleRe: Web Database
Oracle8概 述从Technet那里拿的Oracle光盘版本有什么限制?
求职Oracle DBA请教oracle8如何用
how to do a case insensitive comparisonoracle和XML
[转载] 问个SQL问题[转载] what's the equivalent of 'minus' (oracle) in access?
相关话题的讨论汇总
话题: date话题: blah话题: select话题: oracle话题: where