iTime to convert to Date/Time of hit

[mortirolo]

SELECT vd, policyid, srcip, dstip, itime, service, count(*) AS numoftimes, from_itime(itime) as date_time FROM $log where $filter GROUP BY vd, policyid, srcip, dstip, itime, service ORDER BY numoftimes DESC

itime does not dispaly as date and time, is there anyway I can convert so the report displays date/time

my synatx test works, but displays numbers rather than hour of the day etc

thanks

[RobertReynolds]

SELECT vd, policyid, srcip, dstip, to_char(from_itime("itime"), 'HH24:MI' ) as hour, service, count(*) AS numoftimes, from_itime(itime) as date_time FROM $log where $filter GROUP BY vd, policyid, srcip, dstip, itime, service ORDER BY numoftimes DESC

[mortirolo]

Thanks worked like a peach!