How do I access time portion of date fields?

Stephanie_Ellis_(HARMUser1_(Delete)_2309475)

I can see the time (mm/dd/yy hh:mm:ss) when I view the contents of daudit.auditdate but I cannot query based on this format. It will only allow me to query based on the "mm/dd/yy" portion. If I try to query based on the full length of the field, I get a data format error.Anyone know how to use the time portion of the auditdate field?Thanks,--Stephanie

Bob_De_Garmo_(degarmob_(Delete)_2518944)

Try something like this:select * from dauditwhere daudit.auditdate > to_date('11/05/2001 11:00:00', 'mm/dd/yyyy hh:mi:ss')order by daudit.auditdate ascNote that I changed your format string for the minutes from 'mm' << which is Month >> to 'mi'