LinuxQuestions.org - [SOLVED] doctrine / postgres

- Programming (https://www.linuxquestions.org/questions/programming-9/)

- - doctrine / postgres - timestamp without timezone (https://www.linuxquestions.org/questions/programming-9/doctrine-postgres-timestamp-without-timezone-943752/)

doctrine / postgres - timestamp without timezone

Hi!

I'm working on what I think is still a small project with some entities. I want to work with timestamp fields defined without timezones.

Now, doctrine complains apparently because for doctrine datetime fields won't include the milliseconds (and that's not the case).

By looking around, I see that the "parser" of datetime fields can be changed with something like this:

Code:

Doctrine\DBAL\Types\Type::overrideType('datetime', 'Doctrine\DBAL\Types\VarDateTimeType');

http://readthedocs.org/docs/doctrine...or-issues.html

Now I don't get an exception but 0s in all those fields, and that's not OK either.

What is the right approach here? Who has faced this before?

Oh.... I think the problem could be somewhere else (didn't see the warnings on PHP because it's a long output). Hold your breath for a while.

Nevermind.... it was my mistake. VarDateTimeType will create PHP Datetime objects for the values. I assumed I could thow them into date('U', aDate) to get the time since UNIX epoch.... I could just ask for aDate->getTimetsmp() instead.

Thanks anyway.