[DC-331] Wrong SQL output from Doctrine_Expression for pgsql with timestamp with time zone field Created: 06/Dec/09 Updated: 05/Jan/10
|Reporter:||Dennis Gearon||Assignee:||Guilherme Blanco|
This is with Symfony 1.3 alpha (which is pretty good) Can't tell you which Doctrine it comes with
(1) pgsql connection
What I'd like to get access to using that Doctrine construct is the
Fortunately, all the databases that I want to use implement
|Comment by Michael Pearson [ 05/Jan/10 ]|
I'm also seeing this with Symfony 1.4.1 (w/Doctrine 1.2). Affects timestampable tables (created_at, updated_at).
also, NOW() AT TIME ZONE 'UTC' translates to LOCALTIMESTAMP(0) AT TIME ZONE 'UTC' (via buildSqlQuery).