[
https://issues.apache.org/jira/browse/PHOENIX-1127?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14078069#comment-14078069
]
James Taylor commented on PHOENIX-1127:
---------------------------------------
In our TO_DATE we support an optional second argument for the date format. We
use the Java SimpleDateFormat parse method underneath which should allows this
type of specification to handle 10/7/2010 3:28:58.117127 PM. Have you tried
that?
Barring that, another option in 3.1/4.1 is to import the date as a long. If
Oracle let's you get the Epoch time, then you can use our CAST(my_date_as_long,
DATE) to import it.
> 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)
