Hi Gabriel, Thanks for your response.
You meant to say TO_DATE is actually holding the time portion but it is not able to display it sqlline? Can please correct me if I m wrong. createdate column is defined as string on lead view. Thanks, Siva. On Fri, May 1, 2015 at 3:38 AM, Gabriel Reid <[email protected]> wrote: > Hi Siva, > > The TO_DATE function returns a java.sql.Date value, and the string > representation of the java.sql.Date value is what you're seeing in your > sqlline session. > > The internal long representation of the Date value coming out of TO_DATE > will represent the date to millisecond granularity however. > > - Gabriel > > On Fri, May 1, 2015 at 11:50 AM Siva <[email protected]> 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. >> >
