John wrote: > On Monday 16 November 2009 01:09:48 pm Paul McNett wrote: >> I can solve my issue by just removing the tcreated field from my bizobj >> - I haven't used it for years and its been filling up with 0001-01-01 >> dates for all that time. > > "0001-01-01" I believe is the standard for SQL 92. Therefore it sounds like > the MySQL adapter has the bug. You sure there is no setting your missing?
Yes, "0001-01-01" is what used to be sent by Dabo, and MySQL liked it as a date just fine. The adapter was fine because it was already converted to a string in a mysql-expected format. The adapter shouldn't rely on date.strftime() since it doesn't support valid dates < 1900. There may be options for controlling the adapter. For instance, I think Dabo could override the function used to convert dates to string. Paul _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev Searchable Archives: http://leafe.com/archives/search/dabo-dev This message: http://leafe.com/archives/byMID/[email protected]
