drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jason Altekruse <ja...@dremio.com>
Subject Re: Date Formatting Question
Date Thu, 08 Sep 2016 22:14:26 GMT
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 <kkhatua@maprtech.com> 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 <cgivre@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
> > >
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message