i have got one error today
ORA-01861: literal does not match format string (DBD ERROR: error possibly near <*> indicator at char 240 in 'SELECT COUNT(DISTINCT(st.id)) FROM ticket st, queue sq , ticket_history th WHERE sq.id = st.queue_id AND st.id = th.ticket_id AND sq.group_id IN (25, 44) AND th.history_type_id IN (1, 27) AND th.state_id IN (2, 3) AND th.create_time <= <*>'2011-11-22 23:59:59' AND th.history_type_id IN (1, 27) AND th.state_id IN (2, 3) AND th.create_time >= '2011-11-22 00:00:00''), SQL: 'SELECT COUNT(DISTINCT(st.id)) FROM ticket st, queue sq , ticket_history th WHERE sq.id = st.queue_id AND st.id = th.ticket_id AND sq.group_id IN (25, 44) AND th.history_type_id IN (1, 27) AND th.state_id IN (2, 3) AND th.create_time <= '2011-11-22 23:59:59' AND th.history_type_id IN (1, 27) AND th.state_id IN (2, 3) AND th.create_time >= '2011-11-22 00:00:00''
could any one help to solve this
literal does not match format string
Moderator: crythias