Hi there, I'm using NHibernate 1.2.0.4 on SQL Server 2005. I am using
a Criteria query with a clause as follows:
crit.Add(new NHibernate.Expression.LeExpression("PartnershipDate", new
DateTime(DateTime.Now.AddYears(lengthOfMarriage * -1).Year,
DateTime.Now.Month, DateTime.Now.Day)));
This generates the following log entry sql (I've replaced the field
names with * for clarity):
SELECT * FROM WPR_Test.dbo.[MP] this_ WHERE this_.[IsImportTemp] = @p0
and this_.[PartnershipDate] <= @p1; @p0 = 'False', @p1 = '08/07/2006
00:00:00'
However, this query is not generating the expected results. Using sql
profiler, I checked the actual statement run, which is this:
exec sp_executesql N'SELECT * FROM WPR_Test.dbo.[MP] this_ WHERE this_.
[IsImportTemp] = @p0 and this_.[PartnershipDate] <= @p1',N'@p0 bit,@p1
datetime',@p0=0,@p1='2006-07-08 00:00:00:000'
As you can see, the date '2006-07-08 00:00:00:000' from profiler does
not match the date from the log which is '08/07/2006 00:00:00' as the
profiler query is saying the 7th August, whereby the log query is
saying the 8th July.
Obviously this is a simple mis-formatting, I have all the source code
for the version I'm using, but I can't find where this formatting
happens to correct it. If anyone could point me at the relevant part
of the code I'd appreciate it :)
Regards, Ben
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en
-~----------~----~----~----~------~----~------~--~---
