drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From John Omernik <j...@omernik.com>
Subject Re: Non-Data people producing data: Any thoughts and handling a poor Date/time format?
Date Mon, 08 Feb 2016 18:34:08 GMT
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 <john@omernik.com> 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?
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message