Enhanced Security Measures in Place: To ensure a safer experience, we’ve implemented additional, temporary security measures for all users.
10-18-2024 09:27 AM
I have trying to create a new field with existing string field (cretedDate) which is already in a ISO 8601 format but. unable to parse it
sample value of feild createdDate=2019-08-29T10:10:26.608Z
here below the query i have used
| alter filedate = parse_timestamp("%Y-%m-%dT%H:%M:%S.%fZ", createdDate)
Anybody help me to sort this out
10-21-2024 08:35 AM
Hi @SUDHAKARVEL, thanks for reaching us using the Live Community.
Please take a look at the parse_timestamp documentation here: https://docs-cortex.paloaltonetworks.com/r/Cortex-XDR/Cortex-XDR-XQL-Language-Reference/parse_timest...
Looks like you are missing the format_string function.
If this post answers your question, please mark it as the solution.
Click Accept as Solution to acknowledge that the answer to your question has been provided.
The button appears next to the replies on topics you’ve started. The member who gave the solution and all future visitors to this topic will appreciate it!
These simple actions take just seconds of your time, but go a long way in showing appreciation for community members and the LIVEcommunity as a whole!
The LIVEcommunity thanks you for your participation!
