Convert UNIX timestamp parser

Configuration options

  • Time zone - The time zone used when converting the timestamp into the returned date and time.
  • Format - The format in which the date and time should be returned. [PHP date characters][php-date] are used for format designation.

Common format characters

Character Output
Y Four-digit year.
m Two-digit month.
d Two-digit day of month.
H 24-hour hour value.
i Minutes.
s Seconds.

Examples:

Y-m-d
Y-m-d H:i:s
d/m/Y
Y-m-d\TH:i:s

Use literal separators such as hyphens, slashes, spaces and colons directly in the format.

Time zone affects the returned value

The selected time zone determines the date and time shown in the output.

Use a consistent time zone when comparing data across regions, or select the relevant local time zone when the output is intended for a specific market.

Add the scrape time

You can also use the parser to add the time when each record was scraped.

  1. Select + Add time scraped.
  2. Select the required time zone.
  3. Choose the date and time format.
  4. Preview the result.

Convert an existing timestamp field

Use the parser on an existing column when the source website provides a UNIX timestamp and you want to convert it to a readable date and time.

Use a Virtual column if you also need to keep the original timestamp.

Parser order

The parser must receive the timestamp value itself. If the source contains additional text, extract the timestamp first using other parsers.

Raw source
→ Regex match
→ Convert UNIX timestamp

Troubleshooting

  • Preview the raw value if the conversion fails or looks incorrect.
  • Check that earlier parsers have not added extra text.
  • Verify the selected time zone if the time is unexpected.
  • Check the date format if the output is formatted incorrectly.

Related