java - 开始日期和结束日期查询不起作用

Question

以下是要求

如果搜索日期范围为 5/15/2013 至 5/21/2013，则将包含或排除具有以下事件日期范围的事件:

1/01/2013 to 6/30/2013 include
2/15/2013 to 3/15/2013 exclude
5/01/2013 to 5/19/2013 include
5/01/2013 to 5/14/2013 exclude
5/15/2013 to 5/15/2013 include
5/21/2013 to 5/21/2013 include
5/17/2013 to 5/30/2013 include
5/16/2013 to 5/20/2013 include
5/22/2013 to 5/30/2013 exclude
*5/16/2013 to 00/00/0000 include
5/22/2013 to 00/00/0000 exclude*

下面是我所做的查询，但它不符合上述条件

SELECT cm_id,cm_date_from,cm_date_to FROM Cat_Master
WHERE TRUE  AND ( "2013-05-15" BETWEEN cm_date_from AND cm_date_to OR "2013-05-21" BETWEEN cm_date_from AND cm_date_to
    OR "2013-05-15" >= cm_date_from AND "2013-05-21" <= cm_date_to   OR "2013-05-15" <= cm_date_from AND "2013-05-21" >= cm_date_to
    )

请指导以上查询谢谢

Answer 1

TO_DATE( string1, [ format_mask ], [ nls_language ] )

TO_DATE('2013-05-15,'yyyy-mm-dd')。

对于日期比较，请使用日期变量。

P.S:我假设您正在使用 Oracle Db(因为您没有提及)