TimeStamp From "yyyy/mm/dd hh:mi:ss AM/PM"
Posted: Fri Nov 03, 2006 9:56 am
I have some flat file data that contains timestamps in the form of "YYYY/MM/DD HH:MI:SS AM/PM". I need to convert it to Oracle timestamp In the target Database.
Using a server job, I simple created a routine to do the transformation. However, the requirement is to have it done in a parallel job. What are some techniques to accomplish this?
Basically, I am thinking that I need to parse the last two chars and if they are PM, add 12 to the hour portion of the time. Then strip off the last two chars....Any suggestions on how to do in a parallel job?
Using a server job, I simple created a routine to do the transformation. However, the requirement is to have it done in a parallel job. What are some techniques to accomplish this?
Basically, I am thinking that I need to parse the last two chars and if they are PM, add 12 to the hour portion of the time. Then strip off the last two chars....Any suggestions on how to do in a parallel job?