使用NHibernate HQL中的字符串查询Oracle Date字段 [英] Querying an Oracle Date field using a string in NHibernate HQL

问题描述

我正在尝试查询.NET DateTime属性，并将其与日期字符串进行比较，如下所示:

I'm trying to query a .NET DateTime property and compare it with a date string like so:

SELECT cat FROM mydll.cats AS cat
WHERE cat.BirthDay > '1999-02-20'

当我尝试按日期字符串进行搜索时(不带SetDate函数) 查询不会运行，说明我无法将字符串与日期进行比较.

When I'm trying to search by a date string (without the SetDate function) The query won't run saying I canno't compare a String to a Date.

是否可以使用某种方式或某种格式将我的日期与一个简单的字符串进行比较 (也许类似于Oracle SQL中的ToDate函数.)
*由于设计问题，我需要将HQL字符串与NHibernate引擎分开

Is there a way or a certain format I can use to compare my date with a simple string (Maybe something like the ToDate function in Oracle SQL..)
*I need to separate the HQL string from the NHibernate engine because of design issues

非常感谢[=

推荐答案

to_date函数映射到Oracle方言中，因此:

The to_date function is mapped in the Oracle dialect, so:

SELECT cat FROM mydll.cats AS cat
WHERE cat.BirthDay > to_date('1999-02-20', 'yyyy-mm-dd')

这篇关于使用NHibernate HQL中的字符串查询Oracle Date字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！