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
Showing posts with label Oracle. Show all posts
Showing posts with label Oracle. Show all posts
Thursday, 21 April 2011
Subscribe to:
Posts (Atom)