QuestionQ65Verified/Search and Investigation ToolsCopy linkReport a problemAsk AstroTutorSave questionWhich query function outputs the converted time as 2021/11/26 06:54:45 when the timezone is UTC?Aformattime("%A %d %B %Y, %R", as=fmttime, field=@timestamp/ timezone=Z/ unit=milliseconds)Bformattime("%A %d %B %Y, %R", as=fmttime, field=@timestamp, timezone=UTC, unit=milliseconds)CformatTime("%Y/%m/%d %H:%M:%S", field=@timestamp, locale=en_US, timezone=Z)DformatTime("%Y/%m/%d %H:%M:%S", field=@timestamp, locale=UTC)Show AnswerAnswerExplanationFalcon LogScale formatTime() uses %Y/%m/%d %H:%M:%S to produce a year/month/day and 24-hour time with seconds. Setting timezone=Z formats the timestamp in UTC; Z is the UTC timezone designator.Learn moreformatTime() — LogScale DocumentationShow comments0Show commentsCommunity DiscussionNo comments yet. Be the first to start the discussion!
Community Discussion