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>