thanks it works!
2016-02-12 17:53 GMT+01:00 Andries Engelbrecht <[email protected]>:
> You can use to_timestamp to get the timestamp and then just cast the date
> and time from the timestamp.
>
> 0: jdbc:drill:> select CAST(to_timestamp('2016/01/16 09:44:28 UTC',
> 'YYYY/MM/dd HH:mm:ss z') as date) from (values(1));
> +-------------+
> | EXPR$0 |
> +-------------+
> | 2016-01-16 |
> +-------------+
> 1 row selected (0.148 seconds)
> 0: jdbc:drill:> select CAST(to_timestamp('2016/01/16 09:44:28 UTC',
> 'YYYY/MM/dd HH:mm:ss z') as time) from (values(1));
> +-----------+
> | EXPR$0 |
> +-----------+
> | 09:44:28 |
> +-----------+
> 1 row selected (0.15 seconds)
>
> --Andries
>
> > On 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
>
>
