Product DocumentationParquet Date and Time Conversion
This section shows how date and time logical types are converted and formatted as VARCHAR columns when parquet source files are loaded into Yellowbrick tables. These conversions conform to the ISO-8601 standard.
The TIME and TIMESTAMP conversions produce the shortest string that contains the full time value, with any omitted parts implied to be zero.
| Parquet Type | VARCHAR Column Format | Examples |
|---|---|---|
DATE | uuuu-MM-dd | 2022-03-10 |
TIME | HH:mmHH:mm:ssHH:mm:ss.SSSHH:mm:ss.SSSSSSHH:mm:ss.SSSSSSSSS | 17:48:17.481 |
TIMESTAMP | uuuu-MM-dd'T'HH:mmXXXXXuuuu-MM-dd'T'HH:mm:ssXXXXXuuuu-MM-dd'T'HH:mm:ss.SSSXXXXXuuuu-MM-dd'T'HH:mm:ss.SSSSSSXXXXXuuuu-MM-dd'T'HH:mm:ss.SSSSSSSSSXXXXX | 2022-03-10T17:52:26.219Z2022-02-17T23:29:57.713215Z |
TIMESTAMP | uuuu-MM-dd'T'HH:mmuuuu-MM-dd'T'HH:mm:ssuuuu-MM-dd'T'HH:mm:ss.SSSuuuu-MM-dd'T'HH:mm:ss.SSSSSSuuuu-MM-dd'T'HH:mm:ss.SSSSSSSSS | 2022-03-10T17:52:26.260 |
Parent topic:Loading Tables from Parquet Files