phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Siva <sbhavan...@gmail.com>
Subject Re: TO_DATE is not working as expected
Date Mon, 04 May 2015 23:54:32 GMT
Thanks Gabriel, tried using JAVA and I could see time portion. Also tried
(to_date(c1) - to_date(c2))*24*60*60 in phoenix shell, which resulted the
difference in seconds.

@Nick: I found  !outputformat option in sqlline, but it does not seem like
we can use this to change the output format of particular column. May be I
m not aware of.

Thanks,
Siva.

On Mon, May 4, 2015 at 9:41 AM, James Taylor <jamestaylor@apache.org> wrote:

> FWIW, there's an option in sqlline that will cause it to display the
> full date granularity, but I don't know what it is. Maybe someone else
> does?
>
> Thanks,
> James
>
> On Mon, May 4, 2015 at 12:00 AM, Gabriel Reid <gabriel.reid@gmail.com>
> wrote:
> > Hi Siva,
> >
> > Yes, that's pretty much correct -- TO_DATE is returning a Date value,
> which
> > has millisecond granularity -- the fact that you're only seeing a date
> (with
> > no time component) is due to the way in which the Date is formatted, and
> not
> > it's internal value.
> >
> > - Gabriel
> >
> > On Sun, May 3, 2015 at 5:27 AM Siva <sbhavanari@gmail.com> wrote:
> >>
> >> Any help on TO_DATE function?
> >>
> >> Thanks
> >>
> >> On Fri, May 1, 2015 at 2:49 AM, Siva <sbhavanari@gmail.com> wrote:
> >>>
> >>> Hi,
> >>>
> >>> Phoenix TO_DATE is truncating the time portion from date while
> converting
> >>> the date. Do I need to change the syntax? As per the documentation
> syntax
> >>> seems to be correct.
> >>>
> >>> 0: jdbc:phoenix::/hbase> select "createdate", to_date("createdate",
> >>> 'yyyy-MM-dd HH:mm:ss') from "lead" limit 5;
> >>>
> >>> +------------------------------------------+------------------------+
> >>> |                createdate                | TO_DATE(cf.createdate) |
> >>> +------------------------------------------+------------------------+
> >>> | 2015-03-17 00:00:00.000                  | 2015-03-16             |
> >>> | 2014-04-28 13:31:22.687                  | 2014-04-28             |
> >>> | 2014-04-29 08:42:09.317                  | 2014-04-29             |
> >>> | 2014-04-29 08:42:18.167                  | 2014-04-29             |
> >>> | 2014-04-29 08:42:31.963                  | 2014-04-29             |
> >>> +------------------------------------------+------------------------+
> >>> 5 rows selected (0.056 seconds)
> >>>
> >>>
> >>> Thanks,
> >>> Siva.
> >>
> >>
> >
>

Mime
View raw message