[DDC-745] DateTime with SQLite Created: 12/Aug/10 Updated: 13/Aug/10 Resolved: 12/Aug/10
|Project:||Doctrine 2 - ORM|
|Reporter:||Rui Lima||Assignee:||Benjamin Eberlei|
Windows 7 - Portuguese Regional Settings
I was using 2.0.0-Beta3 no problems found.
Fatal error: Uncaught exception 'Doctrine\DBAL\Types\ConversionException' with message 'Could not convert database value "2010-08-07 00:00:00.000" to Doctrine Type datetime' in
I guess it's an ORM's problem.
I've traced to:
in Doctrine\DBAL\Types\DateTimeType->convertToPHPValue() i receive the values:
I'm new to Doctrine, maybe is my problem but it was working before i've upgraded everything.
|Comment by Rui Lima [ 12/Aug/10 ]|
I took a closer look to my problem.
So, there is no problem.
|Comment by Benjamin Eberlei [ 12/Aug/10 ]|
Does sqlite allow microseconds by default?
|Comment by Rui Lima [ 13/Aug/10 ]|
I don't quite understand you question.
both of the following works:
And here: http://www.sqlite.org/lang_datefunc.html
On other hand when i execute:
So i guess the default is with no miliseconds.
Could we make possible to specify the datetime format in the annotation reference?