CURRENT_TIMESTAMP AT TIME ZONE 'UTC'

[Jonathan Vanasco]

i need to replace my calls to `sqlalchemy.func.current_timestamp()`
with something that generates "CURRENT_TIMESTAMP AT TIME ZONE 'UTC'"

anyone have quick advice ?

[Audrius Kažukauskas]

I have answered this question on StackOverflow, if others are
interested:

http://stackoverflow.com/questions/15424199/howto-current-timestamp-at-time-zone-utc

--
Audrius Kažukauskas
http://neutrino.lt/

[Jonathan Vanasco]

much thanks, Audrius

i ended up doing the following (last night) before i read this in the
morning.

1. s/sqlalchemy\.func\.current_timestamp/sql_now/g
2. def sql_now(): return sqlalchemy.sql.text("(CURRENT_TIMESTAMP AT
TIME ZONE 'UTC')")

i'm working on implementing your more-proper method now. i figured by
creating the sql_now function, i could quickly limit the amount of
future edits. it thankfully worked!