:) @rquadling I think, the field can be populated by either the database engine or the application.Making it portable across different database engines is not as easy as making it updated by the application.I'm still randomly failing on updating a row with a column object containing a Date Time.I originally reported this problem at: The error also happens in the REST console. For storage requirements, see Data Type Storage Requirements. 'Maria DB 10.1.2 introduced the --mysql56-temporal-format option, on by default, which allows Maria DB to store DATETMEs using the same low-level format My SQL 5.6 uses.
i need that i dont want to insert values in that column from the front end. whenever i insert a row in that table the date Time column must be updated with current date and time.
Subtracting 100 from the Style (format) number will transform dates without century (YY).
For example Style 103 is with century, Style 3 is without century.
You have know their inner workings pretty well not to make mistakes with date handling.
This cookbook entry holds several interesting pieces of information on how to work with PHP Date Time instances in Doctrine 2.