Skip to main content
mortirolo
mortirolo
New Member
July 20, 2017
Question

iTime to convert to Date/Time of hit

  • July 20, 2017
  • 1 reply
  • 5099 views

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

    1 reply

    RobertReynolds
    RobertReynolds
    New Member
    July 21, 2017

    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
    mortiroloAuthor
    New Member
    July 21, 2017

    Thanks worked like a peach!

    Terms & ConditionsAccessibility statement