The equivalent of Oracle's SYSDATE in Postgres is CURRENT_TIMESTAMP.
At least in the context I needed it in!
I learnt about timestamp arithmetic in Postgres from here: http://wiki.postgresql.org/wiki/Working_with_Dates_and_Times_in_PostgreSQL#WORKING_with_DATETIME.2C_DATE.2C_and_INTERVAL_VALUES
0 comments:
Post a Comment