Would EXTRACT help ? http://drill.apache.org/docs/date-time-functions-and-arithmetic/#extract
On Fri, Feb 12, 2016 at 7:15 AM, Paolo Spanevello <[email protected]> wrote: > Dear All, > > I have a field with a date like this: > > > Date > > 2016/01/16 09:44:28 UTC > I would like to split it in Date, Time and remove "UTC". > > Somebody can support me? > > Best, > Paolo > -- Abdelhakim Deneche Software Engineer <http://www.mapr.com/> Now Available - Free Hadoop On-Demand Training <http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available>
