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.

Your Feedback. Our Roadmap. Visit the PX Feedback Booth at .conf26

Agentic SOC Triage: Investigating Splunk ES Notables with MCP Server and a Local LLM

Painting a Clearer Picture: Creating Cross-Domain Visibility with AI Canvas

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.

Your Feedback. Our Roadmap. Visit the PX Feedback Booth at .conf26

Agentic SOC Triage: Investigating Splunk ES Notables with MCP Server and a Local LLM

Painting a Clearer Picture: Creating Cross-Domain Visibility with AI Canvas