drill-user mailing list archives

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