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"))))
Cheers!!!!
Moderators: chulett, rschirm, roy
Code: Select all
Convert(' ','',Convert(':','',Convert('-','',TimestampToString(DSJobStartTimeStamp,"%yyyy-%mm-%dd %hh:%nn:%ss"))))
Code: Select all
Convert("-/:. ", "", TimestampToString(DSJobStartTimestamp, "%yyyy-%mm-%dd"))