created date

[lgaorcl]

I checked there are objects created 14-FEB-2005. So I am trying to get all the objects created yesterday.

Select object_name from user_objects
where created = to_date('02/14/2005', 'mm/dd/yyyy');

But there is no row selectd.

Why? And how could I get the objects created yesterday?

THanks!

[marist89]

Are you serious? Think about it for a minute. Look at your data.

[lgaorcl]

Yes, I am serious! Please help!

[marist89]

What time is to_date('02/14/2005', 'mm/dd/yyyy')?

[slimdave]

Hint: the date column also has a time associated with it, which you cannot see because your default date format does not include it.

[lgaorcl]

Please let me know! It's urgent for me! I always have problem with date.

Thanks!

[lgaorcl]

I did:

select object_name from user_objects
where created = to_date('14-FEB-2005', 'DD-MON-YYYY HH24:MI');

no row selected.

[slimdave]

Originally posted by lgaorcl
I did:

select object_name from user_objects
where created = to_date('14-FEB-2005', 'DD-MON-YYYY HH24:MI');

no row selected.

i) You need to go read the SQL Reference, and understand what a DATE data type is, as opposed to how it's presented in SQL*Plus.

ii) select to_char(object_name,'DD-MON-YYYY HH24:MI:SS') from user_objects

[marist89]

Originally posted by lgaorcl
Please let me know! It's urgent for me! I always have problem with date.

Since you don't understand what they are, I'm not surprised.

[gkj2000]

Try this

select object_name from user_objects
where created > to_date('14-FEB-2005', 'DD-MON-YYYY HH24:MI')