DSXchange

To keep it simple, the job reads from a sequential file a timestamp in the default format and loads the date and time as separate fields in an Oracle database.

No, it's still a Timestamp column. I guess under the hood DataStage treats Timestamp fields as a string.

As anudeepdasari001 mentioned, I used substring and it works this way. I still don't know why the functions I mentioned above don't work.

Hello, I'm trying to extract the time from a Timestamp column as an integer. For example, for a timestamp like "2017-06-15 12:30:55", I want to output an integer equal to 1230. I have mainly 2 issues I need to understand: First, I tried using the following function: TimestampToDecimal(DSLi...