Re: Date Formatting Question

Thank you to everyone for your help. I have to admit, that is probably the most non-intuitive function name to accomplish this task. ;-) — C > On Sep 8, 2016, at 18:17, Andries Engelbrecht > wrote: > > And I meant to use MM not mm :-( > > 0: jdbc:drill:> select

Re: Date Formatting Question

Looks like Jason just beat me to it :-) > On Sep 8, 2016, at 3:15 PM, Andries Engelbrecht > wrote: > > You are likely looking for the to_char function to convert date to a > different string format. You can always convert back to a date by using > to_date. > >

Re: Date Formatting Question

You are likely looking for the to_char function to convert date to a different string format. You can always convert back to a date by using to_date. select current_date, to_char(current_date,'mm/dd/') from (values(1)); +---+-+ | current_date | EXPR$1|

Re: Date Formatting Question

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 > >

Re: Date Formatting Question

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