Details
New Feature
Resolved
Major
Description
As we read in the documentation, 'datetime' fields are casted by Doctrine to PHP DateTime class objects. However, when we want to get only certain fields from a table using DQL, Doctrine casts the datetime value to ordinary string. Consider the following example:
/** * @var DateTime $active * * @Column(name="registered", type="datetime") */ private $registered;
var_dump($em->createQuery('SELECT u.id, u.registered FROM Entities\\User u')->getResult());
Expected result:
- The returned row contains DateTime object for 'registered' column.
Actual result:
- The returned row contains string for 'registered' column.
If this is an intended feature, first of all, it should be clearly pointed in the documentation that Doctrine types do not apply in such situations, and secondly, I think it is a very bad practice. I use Doctrine and tell him I have a datetime field in order to get Datetime objects automatically, not to deal with manual conversions.
Activity
ORM - the newest one from Git. I couldn't find any matching version in the issue form, so I selected nothing.
DBAL - the version that currently works with ORM. I've already noticed that DBAL-master does not work with the newest ORM 
.
I think we should really fix this using an additional bit of information on the ResultSetMapping to hint the hydrators which type a scalar value is, if its an entity field, otherwise do nothing in conversion.
Array or Object fields, or even complex objects and serialization structs are pretty useless otherewise
oh wait, i am just now looking at your query, you are retrieving the values as scalar fields, that is something totally different. Let me check the code on this issue.