Support Forum
The Forums are a place to find answers on a range of Fortinet products from peers and product experts.
mortirolo
New Contributor

iTime to convert to Date/Time of hit

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

2 REPLIES 2
RobertReynolds
Contributor

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!

Announcements

Select Forum Responses to become Knowledge Articles!

Select the “Nominate to Knowledge Base” button to recommend a forum post to become a knowledge article.

Labels
Top Kudoed Authors