DSXchange

Posted: **Fri Aug 26, 2011 12:48 am**

Hi Guys,

I need to convert DSJobStartTimeStamp to integer.

Currently am using the below code to convert it.

Convert(' ','',Convert(':','',Convert('-','',TimestampToString(DSJobStartTimeStamp,"%yyyy-%mm-%dd %hh:%nn:%ss"))))

Is there any better way to do it?

Cheers!!!!

Posted: **Fri Aug 26, 2011 1:52 am**

You only need one Convert() function.

Convert("-/:. ", "", TimestampToString(DSJobStartTimestamp, "%yyyy-%mm-%dd"))

Posted: **Fri Aug 26, 2011 2:53 am**

Thanks Ray, thats all i am looking at

Need Help in Convert DSJobStartTimeStamp to integer