SQL: Select conta e group by

[floyd]

togli il trunc e metti to_char(new_time( to_date('01011970','ddmmyyyy') + 1/24/60/60 * call_time, 'GMT', 'EDT' ), 'dd-mon-yyyy hh24:mi:ss' ) nel group by