Jira issue originally created by user ppafford:
only returns one datetime format:
public function getDateTimeTzFormatString()
//return 'Y-m-d H:i:sO'; // original format
return 'Y-m-d H:i:s.uO'; // format also needed
Here is the error I get using the original format:
Could not convert database value "2012-12-07 16:01:52.580789-05" to Doctrine Type datetimetz. Expected format: Y-m-d H:i:s.O
If I use this format: 'Y-m-d H:i:s.uO' it works.
Comment created by ppafford:
adding html tags for code to display correctly
Comment created by @beberlei:
DateTimeTz is created as 'TIMESTAMP(0) WITH TIME ZONE' on DBAL. If you have 'TIMESTAMP(6) WITH TIME ZONE' instead, then you have to create your own datatye.
Issue was closed with resolution "Invalid"
Why would this be a new data type? I understand how to fix the problem with creating my own data type to handle the formatting issue and would even suggest just overriding the data type with
But it's not a new data type, it's a formatting issue.