Yes, of course, but one would think that either SetDateTime would also work for a datetime2 field, or there would be a SetDateTime2 method, since it is a distinct NHibernate field type. It is certainly not intuitive to use SetTimestamp for a datetime2 field.
On Oct 15, 1:16 pm, Fabio Maulo <[email protected]> wrote: > b) for sure... we have various Setxyz for something ;) > > > > On Fri, Oct 15, 2010 at 4:03 PM, Chris J <[email protected]> wrote: > > > I was not able to get Timestamp to work, but it may have been > > complicated by the fact that one of the mappings was for a stored > > procedure call. I was able to get the stored procedure call to work by > > a) changing the stored proc to accept datetime2 instead of datetime, > > and b) using SetTimestamp to set the date parameters on the query > > instead of SetDateTime. If I used SetDateTime, the proc call did not > > include milliseconds. > > > On Oct 14, 12:16 am, Jason Dentler <[email protected]> wrote: > > > NH's Timestamp doesn't truncate or round off. It is as accurate as your > > SQL > > > data type will allow. DateTime2 has a better resolution than DateTime. > > > > On Wed, Oct 13, 2010 at 6:57 PM, Fabio Maulo <[email protected]> > > wrote: > > > > According MsSql documentation it will work perhaps. > > > > If you have MsSql2008 and you use datetime2 then it will work for sure. > > > > > -- > > > > Fabio Maulo > > > > > El 13/10/2010, a las 16:49, Chris J <[email protected]> escribió: > > > > > > Thanks Fabio. If I understand correctly, using Timestamp isn't > > enough, > > > > > because it will still truncate milliseconds, but if I use Timestamp > > > > > AND override TimestampResolutionInTicks to accommodate MsSQL Server > > > > > resolution, that will work? > > > > > > On Oct 13, 10:36 am, Fabio Maulo <[email protected]> wrote: > > > > >> ah... and you have to be aware that MsSQL server DateTime resolution > > is > > > > >> actually 3.33 ms > > > > > >> On Wed, Oct 13, 2010 at 1:34 PM, Fabio Maulo <[email protected]> > > > > wrote: > > > > >>> You have to use type="Timestamp". > > > > >>> If you don't like the round done by default you have to override > > > > >>> YourDialect.TimestampResolutionInTicks > > > > > >>> On Wed, Oct 13, 2010 at 12:58 PM, Chris J <[email protected]> > > wrote: > > > > > >>>> Thank you Nexus. I have seen this blog posting, but it is not very > > > > >>>> helpful. The grid in the posting indicates that a .NET DateTime > > field > > > > >>>> maps to a SQL Server datetime column. While this is true, the > > > > >>>> milliseconds of a DateTime value are not maintained when written > > to > > > > >>>> the database. See this defect: > >http://216.121.112.228/browse/NH-1973. > > > > > >>>> On Oct 13, 4:13 am, Nexus <[email protected]> wrote: > > > > >>>>> Chris > > > > > >>>>> Please take a look at following blog article, should answer your > > > > >>>>> question :) > > > > >http://nhforge.org/blogs/nhibernate/archive/2009/03/11/nhibernate-and. > > > > >>>> .. > > > > > >>>>> Kind regards > > > > > >>>> -- > > > > >>>> 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]<nhusers%[email protected]> > > <nhusers%[email protected]<nhusers%[email protected]> > > > > > <nhusers%[email protected]<nhusers%[email protected]> > > <nhusers%[email protected]<nhusers%[email protected]> > > > > > >>>> . > > > > >>>> For more options, visit this group at > > > > >>>>http://groups.google.com/group/nhusers?hl=en. > > > > > >>> -- > > > > >>> Fabio Maulo > > > > > >> -- > > > > >> Fabio Maulo > > > > > > -- > > > > > 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]<nhusers%[email protected]> > > <nhusers%[email protected]<nhusers%[email protected]> > > > > > . > > > > > For more options, visit this group at > > > >http://groups.google.com/group/nhusers?hl=en. > > > > > -- > > > > 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]<nhusers%[email protected]> > > <nhusers%[email protected]<nhusers%[email protected]> > > > > > . > > > > For more options, visit this group at > > > >http://groups.google.com/group/nhusers?hl=en. > > > -- > > 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]<nhusers%[email protected]> > > . > > For more options, visit this group at > >http://groups.google.com/group/nhusers?hl=en. > > -- > Fabio Maulo -- 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.
