I'm relatively new to Oracle Databases, and I've been stuck on an issue for the past few hours. The Oracle timestamp data type is capable of storing fractional seconds (up to 9 digits, 6 is default).

SELECT class,time_stamp FROM cf_status_log WHERE class like 'any' AND ( time_stamp BETWEEN now() AND ( timestamp with time zone '2013-12-22 17:33:25-0500' - interval '60' minute ) ) order by class ...