Hi Charles, Please see the TO_CHAR function documented on this page [1]. You do not need to use concatenation to achieve this result.
[1] - https://drill.apache.org/docs/data-type-conversion/ Jason Altekruse Software Engineer at Dremio Apache Drill Committer On Thu, Sep 8, 2016 at 3:10 PM, Kunal Khatua <[email protected]> wrote: > 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 <[email protected]> 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 > > > > > >
