Timestamp returning null?

[jisoo23]

I've got a strange problem going on. I have a value that I'm pulling from a flat file which is actually a timestamp (i.e. HH:MM:SS) but is brought in as a string. I use this function to turn it into a timestamp (not date/time stamp):

To_Date(variable,'HH24MISS')

But it returns a null everytime. I've tried to bring it in as both string and a datetimestamp but still get the same result. Has anyone else run into this kind of problem before? The target is a time field on a DB2 table.

Thanks,
Jisoo23

 

[blom0344]

Jisoo,

If I use a flatfile with the time-part as following string:

 17:34:11

then the following expression does the job:

 TO_DATE(variable,'HH24:MI:SS')

You may need to use a SUBSTR action to get the time-part from the string first (my guess)

Ties Blom
Information analyst