Abdel, That worked perfectly! Thank you.
-----Original Message----- From: Abdel Hakim Deneche [mailto:adene...@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 < 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>