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.

Deep Dive: Accelerate threat investigation with Splunk’s AI Assistant in Security

Announcing Modern Navigation: A New Era of Splunk User Experience

Detection Engineering Office Hours: Real-World Troubleshooting & Q&A

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.

Deep Dive: Accelerate threat investigation with Splunk’s AI Assistant in Security

Announcing Modern Navigation: A New Era of Splunk User Experience

Detection Engineering Office Hours: Real-World Troubleshooting & Q&A