presto timestamp bug

[rzj-bigdata]

select timestamp '1946-05-15 00:00:00';
Query 20210304_070605_05374_mzzm9 failed: line 1:8: '1946-05-15 00:00:00' is not a valid timestamp literal

[iceted]

in my experience timestamps are very broken in Presto. This is the best explanation I found about it: trinodb/trino#37 and it appears it the bug was fixed in recent versions of the Trino distribution of Presto: https://trino.io/docs/current/release/release-341.html. Would you like to backport that change?

[v-jizhang]

Yes, it's on our list now. Thanks.

[v-jizhang]

@rzj-bigdata Seems it has been fixed already. Here is my test:

presto> select timestamp '1946-05-15 00:00:00';
          _col0          
-------------------------
 1946-05-15 00:00:00.000 
(1 row)

Query 20210319_150141_00003_53afs, FINISHED, 1 node
Splits: 17 total, 17 done (100.00%)
0:00 [0 rows, 0B] [0 rows/s, 0B/s]