I have a mysql database we are using with Cayenne...The column type in mysql is datetime.
When accessing the returned objects in Cayenne they all have the time set to 00:00:00 but the date is valid. The mysql database has the time and date correct. The java date object is able to handle the time... Not sure what Cayenne is doing to the time portion of the date? It is a straight query against the database to return a list of objects.... Thanks, Tony