RE: [E] Re: Date Format conversion

2016-02-23 Thread Wilburn, Scott
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-t

Re: Date Format conversion

2016-02-23 Thread Abdel Hakim Deneche
more precisely you can use TO_DATE . The following worked for me: TO_DATE('01/25/2016', 'MM/dd/') On Tue, Feb 23, 2016 at 10:48 AM, Neeraja Rentachintala < nrentachint...@maprtech.com> wrote: > Please refer to

Date Format conversion

2016-02-23 Thread Wilburn, Scott
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/, i.e "01/25/2016", into DATE type. Thanks, Scott Wilburn