Oracle 日期比较

发布于 2024-11-10 09:59:17 字数 221 浏览 0 评论 0原文

假设我有以下代码

Some Sql query... 后面跟着这个条件

AND EndDate < TO_DATE('02/14/2011','MM/DD/YY')+1

是否与以下相同

AND EndDate <= TO_DATE('02/14/2011','MM/DD/YY')

原文

Say I have the following code

Some Sql query... is followed by this condition

AND EndDate < TO_DATE('02/14/2011','MM/DD/YY')+1

Is it that same as

AND EndDate <= TO_DATE('02/14/2011','MM/DD/YY')

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

蓝戈者 2024-11-17 09:59:17

注意：我假设根据您的 to_date 格式，EndDate 是日期字段而不是日期/时间数据类型。

两个查询应返回相同的结果集。考虑以下情况：

--Substitue "EndDate" for SYSDATE for this exercise

-- Does "EndDate" occur before June 01, 2011? (Yes)
SELECT 'TRUE'
FROM DUAL
WHERE  TRUNC(SYSDATE) < TO_DATE('05/31/2011','MM/DD/YY')+1

-- Does "EndDate" occur on or before May 31, 2011? (Yes)
SELECT 'TRUE'
FROM DUAL
WHERE  TRUNC(SYSDATE) <= TO_DATE('05/31/2011','MM/DD/YY')

两个结果都将产生“TRUE”。你有什么疑问？

Note: I am assuming based on your to_date formatting that the EndDate is a date field and not a date/time data type.

Both queries should return the same result set. Consider the following:

--Substitue "EndDate" for SYSDATE for this exercise

-- Does "EndDate" occur before June 01, 2011? (Yes)
SELECT 'TRUE'
FROM DUAL
WHERE  TRUNC(SYSDATE) < TO_DATE('05/31/2011','MM/DD/YY')+1

-- Does "EndDate" occur on or before May 31, 2011? (Yes)
SELECT 'TRUE'
FROM DUAL
WHERE  TRUNC(SYSDATE) <= TO_DATE('05/31/2011','MM/DD/YY')

Both results would yield "TRUE". What doubts are you having?

回复收藏 0 原文