It’s the same problem I am facing it can store only one digit in milli seconds so it wont work, The workaournd was do EPOCH but that is not what I am looking at, I want to store it in the same format I am getting and don’t want to make it a string.
Thanks Deepak Gattala From: Bulvik, Noam [mailto:[email protected]] Sent: Saturday, December 13, 2014 11:50 AM To: [email protected] Subject: RE: How do I read all timestamp values with Phoenix What about timestamp(3) I am using the CSV bulk loader tool and it seems like the milliseconds are been truncated when data is inserted to the DB From: [email protected]<mailto:[email protected]> [mailto:[email protected]] Sent: Saturday, December 13, 2014 1:53 AM To: [email protected]<mailto:[email protected]>; [email protected]<mailto:[email protected]> Subject: RE: How do I read all timestamp values with Phoenix “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.“ Thanks Deepak Gattala From: Gattala, Deepak Sent: Friday, December 12, 2014 5:50 PM To: [email protected]<mailto:[email protected]>; [email protected]<mailto:[email protected]> Subject: RE: How do I read all timestamp values with Phoenix I have the same problem I have no idea how to get loaded a time stamp columns Can you please help me because currently the date column si getting truncated when I am loading into it Mm/dd/yyyy HH:MM:SS 115622 Thanks Deepak Gattala From: Mark Kerzner [mailto:[email protected]] Sent: Friday, December 12, 2014 4:41 PM To: [email protected]<mailto:[email protected]> Subject: How do I read all timestamp values with Phoenix Hi, let's say I have 20 values in one column with different timestamps, can I get them all? Thank you, Mark Information in this e-mail and its attachments is confidential and privileged under the TEOCO confidentiality terms that can be reviewed here<http://www.teoco.com/email-disclaimer>.
