Thursday 21 April 2011

SYSDATE in Postgres

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

3 comments:

  1. Great blog! All posts have something to learn. Your work is very good and i appreciate you and hoping for some more informative posts. thanks

    www.n8fan.net

    ReplyDelete
  2. Pretty good post. I found your website perfect for my needs. Thanks for sharing the great ideas.


    Chix
    www.imarksweb.org

    ReplyDelete
  3. The subsequent time I read a blog, I hope that it doesnt disappoint me as much as this one. I imply, I do know it was my option to learn, however I actually thought youd have something attention-grabbing to say. All I hear is a bunch of whining about one thing that you can fix in the event you werent too busy in search of attention. online casino games

    ReplyDelete