How to convert sybase timestamp to Oracl timestamp

us1aslam1us · Post by **us1aslam1us** » Thu Feb 08, 2007 4:59 pm

As you might be aware that PX is too pricky about the Datatypes. A simple solution will be to analyze your Source file at row 90 and you will understand why this row is giving problem. It might be possible that you are passing a Empty value for that field or It is not matching with the length(26).

This might be a typo i guess:

Code: Select all

Jan 10 2007 10:30:31:246AM
should be
Jan 10 2007 10:30:31.246AM

DSguru2B · Post by **DSguru2B** » Thu Feb 08, 2007 6:41 pm

I think the timestamp format is ok. Dont read it as timestamp. Read it as varchar. Feed it to the C routine and let it take care of the rest. Once you get it into correct format and apply StringToTimestamp() to it, it will be fine.
Again, Read it as varchar. The C routine expects a string as its input variable.

jherr22 · Post by **jherr22** » Mon Feb 12, 2007 3:10 pm

Thanks, it is now working.
-- john

ray.wurlod · Post by **ray.wurlod** » Mon Feb 12, 2007 3:23 pm

Please mark thread as resolved.

DSguru2B · Post by **DSguru2B** » Mon Feb 12, 2007 3:23 pm

Good to know. Make sure you add more comments to the routine if required. C is such a language that a few days down the road you wont know what the code is doing.
You can mark the post as Resolved now.