TIMESTAMP TO INTEGER

sush26283 · Post by **sush26283** » Wed Apr 20, 2011 3:31 pm

Hi,

I have a job where, I am using a column say Px_A (source) which is in TIMESTAMP to use it for a column at target say ZX_B which is in integer and I need to get there only the YEAR from the source column PX_A.
Can anyone please guide me how I can achieve that.

Thanks

chulett · Post by **chulett** » Wed Apr 20, 2011 4:14 pm

What is your source, a database? If so, which one? Regardless, it should be as simple as getting the year from the timestamp, which could be just a substring of the first four characters.

sush26283 · Post by **sush26283** » Wed Apr 20, 2011 4:16 pm

both source and target are SQL SERVER

sush26283 · Post by **sush26283** » Wed Apr 20, 2011 4:19 pm

I was initially using link.column [1,4] in the transformer for the derivation of the column but, its giving error that non numeric character present where numeric expected..

chulett · Post by **chulett** » Wed Apr 20, 2011 4:22 pm

What does a timestamp look like after you extract it from SQL Server? Meaning, what format is it in? That will drive where you'll substring the year from.

sush26283 · Post by **sush26283** » Wed Apr 20, 2011 4:55 pm

its in yyyymmdd : hr:mm:ss

chulett · Post by **chulett** » Wed Apr 20, 2011 7:51 pm

If that was true then your [1,4] substring should have worked. Change your target to a flat file, include the timestamp and show us what you get.