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