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 <cgi...@gmail.com> 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( <date>, <format_string>) function > whereby you can change the formatting of a date to whatever you want? > Thanks, > -- Charles >