Date comparison question

Why doesn't this query ever return...

where run_date = to_date('01-03-2001 16:34:59','mm-dd-yyyy hh24:mi:ss')

but this query does....

where to_char(run_date) = to_char(to_date('01-03-2001 16:34:59','mm-dd-yyyy hh24:mi:ss'))

and so does this query....

where to_char(run_date,'mm-dd-yyyy hh24:mi:ss') = '01-03-2001 16:34:59'

?

TIA Lisa   

• Lisa Yates cosnit_at_creighton.edu *
• Creighton University *
• Omaha, Nebraska *
• (402) 280-2419 fax: (402) 280-2573 *
• Define the Universe, give 2 examples. *

  ---