date conversion from small int

hargun · Post by **hargun** » Mon Jan 07, 2013 5:13 pm

Hi,

i am getting the source date field data like "15299 "and small int as datatype and want to convert to date format (yyyy-mm-dd).How can i convert .Which function i will use.Can you provide the whole function syntax.

jwiles · Post by **jwiles** » Mon Jan 07, 2013 5:26 pm

What is the format of the date supplied in the integer?

Regards,

stuartjvnorton · Post by **stuartjvnorton** » Mon Jan 07, 2013 5:54 pm

Days since 1/1/1970, at a guess.

As for spoon-feeding you so that you learn nothing, why don't you have a think about it and try some stuff out first?
Then ask us something specific and you be more likely to get the help you need.

jwiles · Post by **jwiles** » Mon Jan 07, 2013 6:29 pm

Two places in the documentation to help jumpstart the thinking process:

http://publib.boulder.ibm.com/infocente ... tions.html
http://publib.boulder.ibm.com/infocente ... tions.html

Regards,

ray.wurlod · Post by **ray.wurlod** » Mon Jan 07, 2013 7:59 pm

Day zero could be 1968-12-31 if it's come from UniVerse or UniData.

chandra.shekhar@tcs.com · Tue Jan 08, 2013 12:06 am

As asked above you need to find the "Day 0" value.
Mostly it is generic but sometimes project specific like in my project its 1899-12-31.
So once you find it you can use any of the below functions :-

Code: Select all

date('1899-12-31') + n days

If you are having a database as your source.

Code: Select all

DateFromDaysSince(<column>,'1899-12-31')

If you want to do it in transformer.

Also do a Null handling in the transformer if you are using 2nd option, because the record will drop from the transformer if Null comes in the source.