jq Filters and Transformations/Parse custom date format

Parse a custom-formatted date string.

Section: Dates and Time

Parse custom date format

bash
bash
echo '"2025-01-15 12:34:56"' | jq 'strptime("%Y-%m-%d %H:%M:%S")'
Explanation

Returns a time array, which you can convert with `mktime`.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Related commands

Same sheet · prioritizing Dates and Time
Current Unix time
Get the current time as Unix epoch seconds.
OpenIn sheetbashsame section
Unix time to ISO string
Format epoch seconds as an ISO-like UTC string.
OpenIn sheetbashsame section
ISO string to Unix time
Parse an ISO timestamp into epoch seconds.
OpenIn sheetbashsame section
Format epoch as custom string
Render timestamps using a custom format.
OpenIn sheetbashsame section
Logical AND
Filter items that satisfy two conditions.
OpenIn sheetbash1 tag match
Test regex match
Return true if a string matches a pattern.
OpenIn sheetbash1 tag match