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
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
ReplyDeletewww.n8fan.net
Pretty good post. I found your website perfect for my needs. Thanks for sharing the great ideas.
ReplyDeleteChix
www.imarksweb.org
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