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

7 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. I like your post a lot! You should write some more on this!Great job coming with such terrific post!


    faithfully
    mocsbar.com

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


    Chix
    www.imarksweb.org

    ReplyDelete
  4. I really enjoyed reading your article. I found this as an informative and interesting post, so i think it is very useful and knowledgeable. I would like to thank you for the effort you have made in writing this article.


    edupdf.org

    ReplyDelete
  5. Hi, just passing by to see something very interesting and gladly I've found it here. Thank you for your wonderful article it really helped me a lot. You can also visit my site if you have time.

    triciajoy.com

    www.triciajoy.com

    ReplyDelete
  6. Love it! Very interesting topics, I hope the incoming comments and suggestion are equally positive. Thank you for sharing this information that is actually helpful.


    ufgop.org
    ufgop.org

    ReplyDelete