Hi
I have this query over
caseIDs.WhereRestrictionOn(x => x.DateOfAction).
IsBetween(dateAction_from).And(dateAction_to)
and also at the mapping file I use formula = "trunc(DateOfAction)"
it produces this sql
WHERE trunc(this_0_.DateOfAction) between TIMESTAMP '2011-11-01
00:00:00.00' /* :p0 */ and TIMESTAMP '2011-12-03 00:00:00.00' /* :p1
*/
I want to get rid of this TIMESTAMP thing and produce something like
WHERE trunc(this_0_.DateOfAction) between trunc('2011-11-01
00:00:00.00') /* :p0 */ and trunc('2011-12-03 00:00:00.00') /* :p1 */
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to nhusers@googlegroups.com.
To unsubscribe from this group, send email to
nhusers+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en.
