You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by John Omernik <jo...@omernik.com> on 2016/02/08 19:25:11 UTC
Non-Data people producing data: Any thoughts and handling a poor
Date/time format?
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?
Re: Non-Data people producing data: Any thoughts and handling a poor
Date/time format?
Posted by John Omernik <jo...@omernik.com>.
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 <jo...@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?
>