into datetime for conversions
Convert text or timestamp into a datetime.
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--list-human, -n: Show human-readable datetime parsing examples
Parameters
...rest: For a data structure input, convert data at the given cell paths.
Input/output types:
| input | output |
|---|---|
| int | datetime |
| list<string> | list<datetime> |
| record | record |
| string | datetime |
| table | table |
Examples
Convert timestamp string to datetime with timezone offset
> '27.02.2021 1:55 pm +0000' | into datetime
Sat, 27 Feb 2021 13:55:00 +0000 (3 years ago)Convert standard timestamp string to datetime with timezone offset
> '2021-02-27T13:55:40.2246+00:00' | into datetime
Sat, 27 Feb 2021 13:55:40 +0000 (3 years ago)Convert non-standard timestamp string, with timezone offset, to datetime using a custom format
> '20210227_135540+0000' | into datetime --format '%Y%m%d_%H%M%S%z'
Sat, 27 Feb 2021 13:55:40 +0000 (3 years ago)Convert non-standard timestamp string, without timezone offset, to datetime with custom formatting
> '16.11.1984 8:00 am' | into datetime --format '%d.%m.%Y %H:%M %P'
Fri, 16 Nov 1984 08:00:00 +0800 (40 years ago)Convert nanosecond-precision unix timestamp to a datetime with offset from UTC
> 1614434140123456789 | into datetime --offset -5
Sat, 27 Feb 2021 13:55:40 +0000 (3 years ago)Convert standard (seconds) unix timestamp to a UTC datetime
> 1614434140 * 1_000_000_000 | into datetime
Sat, 27 Feb 2021 13:55:40 +0000 (3 years ago)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 │ 2 years ago │
│ 1 │ 2 years ago │
│ 2 │ 2 years ago │
╰───┴─────────────╯Parsing human readable datetimes
> 'Today at 18:30' | into datetimeParsing human readable datetimes
> 'Last Friday at 19:45' | into datetimeParsing human readable datetimes
> 'In 5 minutes and 30 seconds' | into datetime