postgres timestamp broken in 0.6
Issue #1785
resolved
Hey, I tried migrating my sa app to 0.6 but I use the sa.func.TIMESTAMP call. Apparently this is broken in 0.6. It adds parens around the date ie:
select timestamp('04/05/10');
instead of
select timestamp '04/05/10';
Note this is on Postgres 8.4.
Cheers
Comments (2)
-
repo owner -
repo owner - changed status to wontfix
also note that the "TIMESTAMP 'xyz'" syntax is not generally needed as you just bind a
datetime()
to the statement, and the DBAPI handles the type conversion.no test case or further info here so please reopen if further info is available.
- Log in to comment
I'm not familiar with this behavior in any version of SQLAlchemy, and there's no special meaning to "func.TIMESTAMP" I can find going back to 0.3 (only CURRENT_TIMESTAMP and similar). Can you please specify version and attach a test script. You can use the compiler extension for now.