Hi Charles, There isn't a single function that would convert to the format you want, since that would be a user-specific format and not native to the internal Drill representation of the date format.
Treating the output format of 'mm/dd/yyyy' as a string is a solution, using the date-time functions that was shared in the link by tokenizing and concatenating the date tokens of month,date and year. ~ Kunal On Thu 8-Sep-2016 12:20:43 PM, Charles Givre <cgi...@gmail.com> wrote: Hi Khurram, I looked through all that already and I didn't see anything that did what I was wanting to do, or am I missing it? Thanks, -- C On Thu, Sep 8, 2016 at 3:14 PM, Khurram Faraaz wrote: > Here is the link to currently supported datetime functions in Drill > > https://drill.apache.org/docs/date-time-functions-and-arithmetic/#extract > > On Fri, Sep 9, 2016 at 12:32 AM, Charles Givre wrote: > > > Hello everyone, > > I have a question about formatting dates. Let's say that I have some > data > > which has dates in format of yyyy-mm-dd but I would like to convert them > to > > mm/dd/yyyy format (or whatever). Does Drill have something that is > roughly > > equivalent to MySQL's DATE_FORMAT( , ) function > > whereby you can change the formatting of a date to whatever you want? > > Thanks, > > -- Charles > > >
