more precisely you can use TO_DATE
<http://drill.apache.org/docs/data-type-conversion/#other-data-type-conversions>.
The following worked for me:
TO_DATE('01/25/2016', 'MM/dd/YYYY')
On Tue, Feb 23, 2016 at 10:48 AM, Neeraja Rentachintala <
nrentachint...@maprtech.com> wrote:
> Please refer to https://drill.apache.org/docs/date-time-and-timestamp/
>
> On Tue, Feb 23, 2016 at 10:41 AM, Wilburn, Scott <
> scott.wilb...@verizonwireless.com.invalid> wrote:
>
> > Hello,
> > Is there a way to convert other date formats into the DATE type? I would
> > like to cast a field that contains a date in the format mm/dd/yyyy, i.e
> > "01/25/2016", into DATE type.
> >
> > Thanks,
> > Scott Wilburn
> >
> >
>
--
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>
