Need Help in Convert DSJobStartTimeStamp to integer

[mac4rfree85]

Hi Guys,

I need to convert DSJobStartTimeStamp to integer.

Currently am using the below code to convert it.

Code: Select all

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

Is there any better way to do it?

Cheers!!!!

[ray.wurlod]

You only need one Convert() function.

Code: Select all

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

[mac4rfree85]

Thanks Ray, thats all i am looking at