military to standard time conversion

hargun · Post by **hargun** » Thu Jul 03, 2014 1:22 pm

hello,

i am tried to do conversion from military format to standard format.

the job design is

db2 stage...........xfm..................oracle

The source column datatype is char and want to load according to standard time format. The target column datatype is varchar.
the current format is 22.48.51 but in output required 10:48:51 PM

i tried by string to time conversion but not works.

Can you please help me on this.

ray.wurlod · Post by **ray.wurlod** » Thu Jul 03, 2014 2:24 pm

Convert the inbound string to a time using StringToTime() with an appropriate format specification (such as "%hh.%nn.%ss").

Wrap that result in a TimeToString() function with a format string that specifies your desired output format.

rkashyap · Post by **rkashyap** » Thu Jul 03, 2014 3:08 pm

Code for implementing Ray's suggestion is:

Code: Select all

TimeToString(StringToTime(INLink.INTIME,"%hh:%nn:%ss"),"%HH:%nn:%ss %aa")

where INLink.INTIME is incoming time.

hargun · Post by **hargun** » Thu Jul 03, 2014 5:21 pm

thanks it works

ray.wurlod · Post by **ray.wurlod** » Thu Jul 03, 2014 6:28 pm

Give a man a fish...

chulett · Post by **chulett** » Thu Jul 03, 2014 9:34 pm

And in case you are unfamiliar with the Chinese Proverb:

"If you give a man a fish you feed him for a day. If you teach a man to fish you feed him for a lifetime."

We generally prefer to teach fishing around here rather than simply hand out fish.

rkashyap · Post by **rkashyap** » Fri Jul 04, 2014 6:16 am

Point understood. Thanks.