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 state that you can escape a literal with a single quote. IE: yyyy-MM-dd'T'hh:MM:00 However, the issue here is that since Drill does not allow double quotes, all these need to be escaped. yyyy-MM-dd\'T\'hh:MM:00 But... this just doesn't seem to work. I'm using the TO_TIMESTAMP() function. Any suggestions? Thanks, -- C
