friends.. I am trying to test query on oracle test database to list all tables created yesterday with timestamp...
spend 1 hours or so then decided to put here just in case I'm making some silly mistake....
I can get result without timestamp
testdb_sql> select owner, object_name, created from dba_objects
where trunc(created) >= trunc(sysdate-1/24);
don't want to use to_char function... and tried to_date() variations with no result....
rp sb... are you around??