On my "German-Switzerland" machine the SQL Server profiler shows the insert with this parameter: @p5=''1999-12-31 23:00:00:000'' (mapped as a timestamp) which looks quite culture neutral.
On 20 Jan., 12:15, Chris Smith <[email protected]> wrote: > No it doesn't. The column is a DateTime and the object is a DateTime. > The mapping specifies no type. As it goes over the connection > (looking at it from NHprof), it's being sent as a string when doing > the INSERT which is where the confusion is occuring. > > Cheers, > > Chris. > > 2009/1/20 Stefan Steinegger <[email protected]>: > > > > > > > I don't understand the problem. Where does NHibernate "generate a date > > format"? You should have a DateTime in the entity and a date in the > > database. Dates in queries should be passed as parameters, not as > > strings. Doesn't this work? > > > On 19 Jan., 16:38, "[email protected]" > > <[email protected]> wrote: > >> Is there a way to force hibernate to generate a non-locale-specific > >> date format so I can insert dates without worrying about if they are > >> interpreted as US/UK english? > > >> At the moment they are being sent as text i.e. '06/07/2008 > >> 12:14:00'. > > >> Unfortunately some muppet set up our DB and web servers with different > >> locales so 06/07 is ambiguous (US English SQL Server 2005 server, UK > >> English Windows 2008 client). > > >> Using NH 2.0.1 as bundled by spring.net 1.2.0, mssql2005 dialect and > >> sqlserver-2.0 provider. > > >> Any help appreciated. > > >> Cheers, > > >> Chris. > > -- > Chris Smithhttp://www.chrisjsmith.me.uk/ --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
