Woo found TO_TIMESTAMP Thank you Drill Devs from saving me from bad data people!
John On Mon, Feb 8, 2016 at 12:25 PM, John Omernik <[email protected]> wrote: > I could go the route of a udf, but I was trying to think through a hack to > get data from this format: > > 2/6/2016 10:11:05 PM > > Into something useable. > > 1. I am assuming 2/6/2016 means Feb 6th as June 2nd hasn't happened yet > 2. AM/PM... Really *sigh > 3. No Timezone > > So I was thinking about using some strpos/substring stuff, but it seems > prone to failure. > > Thoughts? >
