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.
Timestamp To Numeric
Moderators: chulett, rschirm, roy
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Yes, it will also work if output is integer. Also see Type conversion functions.