Channels
android_tests
apple-silicon
arm-architecture
auditing-warroom
aws
carving
code-review
community-feeds
core
darkbytes
doorman
ebpf
eclecticiq-polylogyx-extension
extensions
file-carving
fim
fleet
fleet-dev
fleetosquery
foundation
fuzzing
general
golang
goquery
infrastructure
jobs
kolide
linen-dev
linux
macos
officehours
osctrl
plugins
process-auditing
querycon
queryhub
random
selfgroup
sql
tls
uptycs
vendor-feeds
website
windows
zeek
zentral
zercurity
Title
m
Mike S.
05/23/2023, 8:24 PMHi all! What would be the best way to convert multiple unixepoch times in a single query? For example, in the wifi_networks table, there is an added_at and captive_login_date that both present in the unixepoch format. Thanks in advance for the help!
Actually, I think I figured it out myself. Posting for posterity:
SELECT *,
datetime(added_at, 'unixepoch') AS added_at,
datetime(captive_login_date, 'unixepoch') AS captive_login_date
FROM wifi_networks;
s
seph
05/24/2023, 12:30 AMYeah, that!