Need to convert itime to actual date/time

[Bill_K]

[align=left]I'm trying to display the actual date/time for a log entry. Using the following dataset, but not sure how to covert itime to an actual date/time or if it is even possible. [/align][align=left] ------------------------------------------------------------------ select  dstip,  `user`, srcip, sum(coalesce(sentbyte,0)+coalesce(rcvdbyte,0)) AS Bandwidth,[/align][align=left]sum($browse_time) as browsetime, itime as date_time from $log where dstip between '198.45.48.0' and '198.45.63.255' group by `user`, dstip, srcip, hostname, date_time order by user asc[/align][align=left]-----------------------------------------------------------------[/align][align=left] [/align][align=left]Any Help is greatly appreciated[/align][align=left]BK[/align][align=left]Note: Using  FortiAnalzyer 1000D, Ver 5.2[/align][align=left] [/align]

[hzhao_FTNT]

Please try: from_itime(itime) as date_time

[Bill_K]

This worked perfectly, thanks.