Trying to convert time format 0:00:00 to seconds (integer), to use as a derive column in SSIS. I’ve tried (DT_I4)TOKEN(column,”:”,1) * 60 + (DT_I4)TOKEN(column,”:”,2), but it is not recognizing the hour portion whether it has a leading zero or not
Trying to convert time format 0:00:00 to seconds (integer), to use as a derive column in SSIS. I’ve tried (DT_I4)TOKEN(column,”:”,1) * 60 + (DT_I4)TOKEN(column,”:”,2), but it is not recognizing the hour portin whether it has a leading zero or not