Time/Date in oracle

To work with timestamps in oracle, use the to_timestamp function.

A time stamp looks like this : 07-NOV-05 03:50:23.553750

delete from sessn where last_used < to_timestamp('14-Dec-04');