You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "James Taylor (JIRA)" <ji...@apache.org> on 2014/07/28 20:46:40 UTC
[jira] [Updated] (PHOENIX-788) Support cast from/to
DATE/TIME/TIMESTAMP to/from LONG/UNSIGNED_LONG
[ https://issues.apache.org/jira/browse/PHOENIX-788?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
James Taylor updated PHOENIX-788:
---------------------------------
Description:
We should support a manual cast between LONG and DATE/TIME/TIMESTAMP, for example:
SELECT CAST(epoch_value AS DATE) FROM t;
SELECT CAST(date AS BIGINT) FROM t;
Requested by Tagged on the mailing list.
was:
We should support a manual cast between LONG and DATE/TIME/TIMESTAMP, for example:
SELECT epoch_value CAST AS DATE FROM t;
SELECT date CAST AS LONG FROM t;
Requested by Tagged on the mailing list.
> Support cast from/to DATE/TIME/TIMESTAMP to/from LONG/UNSIGNED_LONG
> -------------------------------------------------------------------
>
> Key: PHOENIX-788
> URL: https://issues.apache.org/jira/browse/PHOENIX-788
> Project: Phoenix
> Issue Type: Task
> Affects Versions: 3.0-Release
> Reporter: James Taylor
> Assignee: James Taylor
> Fix For: 3.0.0, 4.0.0, 5.0.0
>
>
> We should support a manual cast between LONG and DATE/TIME/TIMESTAMP, for example:
> SELECT CAST(epoch_value AS DATE) FROM t;
> SELECT CAST(date AS BIGINT) FROM t;
> Requested by Tagged on the mailing list.
--
This message was sent by Atlassian JIRA
(v6.2#6252)