Updating/Reading Dates
by Frank Kim on Sep.29, 2005, under Oracle
I always forget how to do this.
UPDATE foo SET bar_date = TO_DATE( '2005-09-29', 'YYYY-MM-DD') WHERE foo_id=51
SELECT TO_CHAR(bar_date, 'yyyy-mm-dd hh24:mi:ss') FROM foo;
SELECT * FROM foo WHERE bar_date > TO_DATE('08/16/2006', 'MM/DD/YYYY')
When you need a date in a pinch for inserting test data use sysdate.
INSERT INTO foo (bar_date) VALUE (sysdate)
A good article about this is Oracle, SQL, Dates and Timestamps.
Related posts:
-
Innovate!
betweenGo is a web solutions provider, specializing in Ruby on Rails and ATG enabled solutions.
If you're interested in becoming a betweenGo client, please contact us.
Please feel free to join the discussion by leaving comments and stay updated by subscribing to the RSS feed.
You can also follow us on Twitter.
You can also subscribe by email by filling the field below:
