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.