ICONV 12-hour format Time Conversion

vaby · Post by **vaby** » Tue Nov 06, 2007 9:07 pm

What am I doing wrong? The following two conversions return the same internal value:

X=ICONV("3:14 AM", "MTH") X=11640
X=ICONV("3:14 PM", "MTH") X=11640

I can do this conversion in SQL, but would prefer to have all such type transformations inside DataStage. Any help is appreciated. This should be simple, right?

Vladimir

chulett · Post by **chulett** » Tue Nov 06, 2007 9:28 pm

From what I recall, it doesn't like the space before the AM or PM when doing 12-hour format conversions. Try removing it and rerunning your tests.

vaby · Post by **vaby** » Tue Nov 06, 2007 9:36 pm

You right, many thanks!

X=ICONV("3:14AM", "MTH") X=11640
X=ICONV("3:14PM", "MTH") X= 54840

Vladimir