java - 将 SQL 查询转换为等效的 Hibernate Criteria

Question

我是 hibernate 新手，我在 MYSQL 中编写了一些查询，但我需要将这些查询转换为 hibernate 标准。

SQL查询

select * from tableName where type = 'some Loss' and (datediff(detection_time,clearing_time )> '15 minutes' or action = 'ACTIVE') and id = '216';

我尝试了一些使用条件的代码，但它似乎不起作用。

Answer 1

您需要正确使用DATEDIFF并指定单位，即MINUTE。

参见Documentation - DATEDIFF (Transact-SQL)

Returns the count (signed integer) of the specified datepart boundaries crossed between the specified startdate and enddate.

Syntax: DATEDIFF ( datepart , startdate , enddate )

尝试这个语法:

SELECT  *
FROM    tableName
WHERE   [type] = 'some Loss'
        AND ( DATEDIFF(MINUTE, detection_time, clearing_time) > 15
              OR action = 'ACTIVE'
            )
        AND id = '216';