[ 
https://issues.apache.org/jira/browse/PHOENIX-1127?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14078306#comment-14078306
 ] 

James Taylor commented on PHOENIX-1127:
---------------------------------------

How are you loading data? Can you post the SQL code? I assume your using our 
TO_DATE(dateAsString) function to attempt to load it. Replace that with 
CAST(dateAsLong AS DATE).

> Cannot load Timestamp(6) from oracle  Example: 10/7/2010 3:28:58.117127 PM. 
> the only option currently is to load it as string and cannot apply andy date 
> manupulations on that column.
> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: PHOENIX-1127
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-1127
>             Project: Phoenix
>          Issue Type: Improvement
>    Affects Versions: 4.0.0
>         Environment: PROD
>            Reporter: Deepak Gattala
>             Fix For: 5.0.0
>
>   Original Estimate: 360h
>  Remaining Estimate: 360h
>
> cannot do any date manipulation because of this issue.



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Reply via email to