into datetime for conversions

Signature

> into datetime {flags} ...rest

Flags

• --timezone, -z {string}: Specify timezone if the input is a Unix timestamp. Valid options: 'UTC' ('u') or 'LOCAL' ('l')
• --offset, -o {int}: Specify timezone by offset from UTC if the input is a Unix timestamp, like '+8', '-4'
• --format, -f {string}: Specify expected format of INPUT string to parse to datetime. Use --list to see options
• --list, -l: Show all possible variables for use in --format flag

Parameters

• ...rest: for a data structure input, convert data at the given cell paths

Input/output types:

Examples

Convert any standard timestamp string to datetime

>'27.02.2021 1:55 pm +0000'|into datetime
Sat, 27Feb202113:55:00+0000 (2yearsago)

Convert any standard timestamp string to datetime

>'2021-02-27T13:55:40.2246+00:00'|into datetime
Sat, 27Feb202113:55:40+0000 (2yearsago)

Convert non-standard timestamp string to datetime using a custom format

>'20210227_135540+0000'|into datetime-f'%Y%m%d_%H%M%S%z'
Sat, 27Feb202113:55:40+0000 (2yearsago)

Convert nanosecond-precision unix timestamp to a datetime with offset from UTC

>1614434140123456789|into datetime--offset-5
Sat, 27Feb202113:55:40+0000 (2yearsago)

Convert standard (seconds) unix timestamp to a UTC datetime

>1614434140*1_000_000_000|into datetime
Sat, 27Feb202113:55:40+0000 (2yearsago)

Convert list of timestamps to datetimes

> ["2023-03-30 10:10:07 -05:00", "2023-05-05 13:43:49 -05:00", "2023-06-05 01:37:42 -05:00"] |into datetime
╭───┬──────────────╮
│0│6monthsago│
│1│5monthsago│
│2│4monthsago│
╰───┴──────────────╯