RE: [E] Re: Date Format conversion

["Wilburn, Scott" <Sc...@VerizonWireless.com.INVALID>]

Abdel,
That worked perfectly! Thank you.


-----Original Message-----
From: Abdel Hakim Deneche [mailto:adeneche@maprtech.com] 
Sent: Tuesday, February 23, 2016 10:53 AM
To: user
Subject: [E] Re: Date Format conversion

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 < nrentachintala@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.Wilburn@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>