Re: Timestamp Issue

2020-02-07 Thread Igor Guzenko
Hello Charles, It seems to work when I use one additional ' for escaping, for example try using '-MM-dd''T''HH:mm:ss' for format. Thanks, Igor On Thu, Feb 6, 2020 at 11:43 PM Ted Dunning wrote: > That is really frustrating because that timestamp is literally in an ISO > 8601 format. > > ht

Re: Timestamp Issue

2020-02-06 Thread Ted Dunning
That is really frustrating because that timestamp is literally in an ISO 8601 format. https://en.wikipedia.org/wiki/ISO_8601 It would be nice if these formats just worked by default. On Thu, Feb 6, 2020 at 5:05 AM Charles Givre wrote: > Hi Drill Devs > I'm having a small issue interpreting

Timestamp Issue

2020-02-06 Thread Charles Givre
Hi Drill Devs I'm having a small issue interpreting timestamps from data. The data in question is in both CSV and parquet format, and has dates encoded as strings in the following format: 1998-07-14T04:00:00 The issue I'm encountering is dealing with the literal T. The JODA instructions stat