Re: Date Formatting Question

2016-09-08 Thread Charles Givre
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 current_date, to_char(current

Re: Date Formatting Question

2016-09-08 Thread Andries Engelbrecht
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. > > select current_date, to_char(

Re: Date Formatting Question

2016-09-08 Thread Andries Engelbrecht
And I meant to use MM not mm :-( 0: jdbc:drill:> select current_date, to_char(current_date,'MM/dd/') from (values(1)); +---+-+ | current_date | EXPR$1| +---+-+ | 2016-09-08| 09/08/2016 | +---+-+ --Andries

Re: Date Formatting Question

2016-09-08 Thread Jason Altekruse
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, Kuna

Re: Date Formatting Question

2016-09-08 Thread Andries Engelbrecht
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

2016-09-08 Thread Kunal Khatua
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/' as a string is a solution, using the date-time fun

Re: Date Formatting Question

2016-09-08 Thread Charles Givre
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/doc

Re: Date Formatting Question

2016-09-08 Thread Khurram Faraaz
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 > wh

Date Formatting Question

2016-09-08 Thread Charles Givre
Hello everyone, I have a question about formatting dates. Let's say that I have some data which has dates in format of -mm-dd but I would like to convert them to mm/dd/ format (or whatever). Does Drill have something that is roughly equivalent to MySQL's DATE_FORMAT( , ) function whereby