Handling time with variable length

sharmabhavesh · Post by **sharmabhavesh** » Wed Oct 07, 2015 12:29 pm

Hi,
I have a time field which can either be hhmmss or hmmss. The hour field can be 1-2 digits without a '0' being prefixed. How can I convert such string to time. I used %(h,s)nnss but that didn't work.

ray.wurlod · Post by **ray.wurlod** » Wed Oct 07, 2015 5:46 pm

I assume that you actually have a string field, since time fields don't have a format (they are stored as binary numbers).

Simply prefix the string with a "0" character and use the rightmost six characters of the result, with "%hh%nn%ss" as the format string.

Code: Select all

Right("0" : InLink.TimeString, 6)

sharmabhavesh · Post by **sharmabhavesh** » Fri Oct 09, 2015 5:52 am

Hi Rar, Thanks for the solution. But can this be handled by specifying a format string. Read at some Datastage documentation to use %(h,s) in the format string but didn't work in my case.

chulett · Post by **chulett** » Fri Oct 09, 2015 7:31 am

The "s" means it can have a leading space. If "1-2 digits without a leading 0" means "1 thru 12" you can just use %h I would think.