In my view, the lack of proper date-time abstraction in the Zend_Db component is the most missing core feature in Zend Framework as any Database Brand expects date-time informations in a different representation.
However in Zend Framework date-time data are greatly abstracted via the Zend_Date component with full Time-zone support!
But when it comes to Zend_Db, this abstraction is of no use, as the component expects data for date-time fields in the db’s native representation.
There is a open issue in the Zend Tracker about this topic. The scheduled fix war for 0.8.0 release
.
Well, never give up Hope is the credo. The issue got updated 3 days ago, setting the target version again to next minor release.Â
Lets all keep finger crossed, as the inclusion of this feature would greatly help to finish the Oracle Back-end of Tine 2.0.

Does “Oracle Back-end” mean that Tine will be based on a Oracle database?
I hope not…
Hi Holger,
Tine 2.0 main database backend is MySQL. As my employer runs HA systems based on mysql farms this will always be the first database we implement things for.
However we plan to add an additional database backend which will be oracle. From my point of view, mysql is perfect, but there are customers, who just _want_ oracle as database.
cu
cornelius
Hi Cornelius,
if the Oracle backend is something additional to MySQL it’s perfect. Additional choice can’t be bad and Oracle seems to be the first choice for many. I am not an expert in databases, so I don’t know why.
However, I know they are quite expensive and MySQL is really wide spread, so I think for a project like Tine it is the number one choice. Support of additional database formats is never a bad thing.
Holger