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 -~----------~----~----~----~------~----~------~--~---
