Tom,

Thank you for your time in advance.

I have a cust_trxn table that contains column trxn_dte_time which is of datatype date. I have a requirement to select the number of transactions that occur between 3.30 PM and 5.30 PM.

In the process of coming up with the time portion of the column I have tried:

SQL> select to_date(trxn_dte_time,'hh:mi:ss') from cl_cust_trxn
2 where cust_trxn_seq=24587811;
select to_date(trxn_dte_time,'hh:mi:ss') from cl_cust_trxn
*
ERROR at line 1:
ORA-01858: a non-numeric character was found where a numeric was expected

How do we select only the time portion of a date datatype.

Appreciate your help.

select to_char(trxn_dte_time, 'hh24:mi:ss')
  from t
 where to_char(trxn_dte_time,'hh24mi' ) between '1530' and '1730';
   and .....