Timestamp To Numeric

Kel · Post by **Kel** » Mon Jul 13, 2015 5:26 am

Hi Everyone,

I have a timestamp column and I wanted it to become a number with format yyyymmdd on the output of a transformer stage. Can anyone suggest method on obtaining this.

Thank you very much.

ArndW · Post by **ArndW** » Mon Jul 13, 2015 5:30 am

Just do a TimeStampToString(Your.Column,"%yyyy%mm%dd") in a numeric column. The function will convert the timestamp to a string, and then an implicit string to numeric conversion will take place.

Kel · Post by **Kel** » Mon Jul 13, 2015 5:58 am

Thank you.

Kel · Post by **Kel** » Mon Jul 13, 2015 6:03 am

Will this also work for Integer datatype?

rkashyap · Post by **rkashyap** » Mon Jul 13, 2015 7:10 am

Yes, it will also work if output is integer. Also see Type conversion functions.