Date Format

jhayIV · ‎06-29-2017

Anyone have any recommendations on how to convert this time date format to a friendly date? I have tried strftime and strptime with no luck
LastScanDate=1485064800

richgalloway · ‎06-29-2017

That's an epoch timestamp. Convert it using strftime as in this run-anywhere example.

| makeresults | eval LastScanDate=1485064800 | eval LSD=strftime(LastScanDate,"%Y/%m/%d %H:%M:%S") | table LastScanDate LSD

---
If this reply helps you, Karma would be appreciated.

Date Format

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Rounding off the Splunk Dashboard Contest

A Four Part Event Series: AI + Observability: AI Agents, LLMs, Apps, & Infrastructure

Splunk Technical Support Is Moving to Cisco Support Tools

Join the Conversation

Date Format

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Rounding off the Splunk Dashboard Contest

A Four Part Event Series: AI + Observability: AI Agents, LLMs, Apps, & Infrastructure

Splunk Technical Support Is Moving to Cisco Support Tools