title: RPAD Numeric values
body: <p>This works fine in Oracle, but not Postgres. Does postgres allow for padding of numeric zeros?</p>
  
  <pre><code>RPAD(REPLACE(CAST(CEIL(MOD(columntimesec, 60)) / 100 AS VARCHAR(3)) , '.','0:'),4,0)
  </code></pre>
  
  <p>This works, but i'd like to pad with numeric values instead</p>
  
  <pre><code>RPAD(REPLACE(CAST(CEIL(MOD(columntimesec, 60)) / 100 AS VARCHAR(3)) , '.','0:'),4,'0')
  </code></pre>