Hi, yes, some work was done on date and times since 0.18 (as far as I remember), but I'm not sure your problem will be fixed anyway. Any suggestion here to fix it is welcome.
Pascal. jabber/gtalk: [email protected] msn: [email protected] On Thu, Mar 19, 2009 at 21:57, <[email protected]> wrote: > > Might have been a little vague on what the problem is, was a bit > stressed at the time. > > We are trying to gather data using a fromDate/toDate > something like s.Date >= fromDate.Date && s.Date <= toDate.Date; > > What i've gathered is that DateTime.Date() sends the Date as YYYY-MM- > DD 00:00:00 instead of just YYYY-MM-DD that the mysql-server is > expecting > We tried using date(time) (in query to mysql) and that gives us the > right answer, i'm not sure what's causing mysql to do this, will try > tomorrow (it's 21:56 atm) to convert the column from datetime to just > date and see if the problem persists. > > Have there been more work done on dbLinqs Date/DateTime handling since > 0.18, thinking i should grab the svn and compile the code? > > On Mar 19, 3:34 pm, [email protected] wrote: > > Been trying out the dbLinq 0.18 for using with a mySQL database and we > > are having some problems when collecting data using .NET DateTime > > > > s.Time == fromDate.Date > > > > should return more then a couple of thousand of hits, but we get 0 > > returns > > we made some research into it and it seems that .NET DateTime sends > > date as "YYYY-MM-DD 00:00:00" > > and it's the time at the end that's causing the problem > > > > We wrote some querys into the DB and with the 00:00:00 at the end, we > > have no returns > > Any ideas how we might work around this? > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "DbLinq" 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/dblinq?hl=en -~----------~----~----~----~------~----~------~--~---
