如何在Oracle 11g SQL中计算两个日期之间的差异 [英] How to calculate difference between two dates in oracle 11g SQL

问题描述

当我尝试通过使用datediff函数计算日期差时，它显示了无效的标识符.

When I am trying to calculate the date difference by using datediff function it showing that invalid identifier.

SELECT DATEDIFF(day,'2008-08-05','2008-06-05') AS DiffDate from da_static_trade.

Error : invalid identifier.

能告诉我日期差的计算功能是什么吗?

Can you please tell me what is the function to calculate date difference.

推荐答案

Oracle中没有DATEDIFF()函数.在Oracle上，这是一个算术问题

There is no DATEDIFF() function in Oracle. On Oracle, it is an arithmetic issue

select DATE1-DATE2 from table 

这篇关于如何在Oracle 11g SQL中计算两个日期之间的差异的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！