Page 1 of 1

How to read time datatype from sequential stage

Posted: Wed Jul 16, 2008 3:28 am
by yulangok
How are you, friends?
I have a ETL task to finish. The source is sequential file, in which a column is time type like:"10:59:40:543AM" or "8:59:40:543PM" .
So any friend can tell me a simple solution to finish it? Many thanks.
Best wishes to you!

Posted: Wed Jul 16, 2008 3:33 am
by ray.wurlod
Read it as VarChar and convert it to Time downstream of the Sequential File stage, as discussed in this thread.