last_ddl_time format

February 3, 2010 at 05:25:42
Specs: Windows XP
i hav to query all_objects table where last_ddl_time='01 jan 2010'
but it refuses the input format...
Any body give me the exact format to query?

See More: last_ddl_time format

Report •

February 5, 2010 at 15:59:08

SELECT created, last_ddl_time, timestamp, object_name, subobject_name, object_type
FROM dba_objects
WHERE TRUNC(last_ddl_time) > '23-jul-2007'
ORDER BY last_ddl_time DESC;

Report •
Related Solutions

Ask Question