title: SQL casting seconds in time stamp to an integer
body: <p>I'm trying to cast the seconds from a time stamp variable in a data set to an integer. So far I've gotten it down to the substring where it just outputs the seconds of a time stamp but for whatever reason, I can't get rid of the letter 'Z' at the end no matter what index I reference when trying to substring so that I can cast the value to an integer. I've included screenshots of my data and my attempt of substringing the value below.</p>
  <p><img src="https://i.imgur.com/zHJ1uwUm.png" alt="Time Column" /></p>
  <p><img src="https://i.imgur.com/XmWt1pd.png" alt="Output" /></p>
  <p>This is my output so far, can anyone help?</p>