title: oracle insert only time
body: <p>I would like to insert data to db as time, not date. If I use <code>to_date('2012-08-31 07:39:33', 'YYYY-MM-DD HH24:MI:SS')</code> it adds date too.
  If I use <code>to_date('09:34:00', 'HH24:MI:SS')</code> it adds year, month, day as well, from nowhere :|
  Later I need to get rows where time is between x and y, not taking in account the year, month or day. How do I do that?
  thanks</p>