title: DB2 Convert milliseconds to timestamp
body: <p>In DB2 I’m trying to convert the number of milliseconds since 01/01/1970 (epoch time), into a suitable date format.</p>
  
  <p>So far I have got this query (where MILLI is 1417493940000, the number of milliseconds) ;</p>
  
  <pre><code>SELECT to_char(TIMESTAMP ('1970-01-01-00.00.00.00000') + (MILLI/1000) SECOND) 
  FROM MYTABLE
  </code></pre>
  
  <p>And it returns, which is ok-ish ;
  Dec 2, 2014 4:19:00 AM</p>
  
  <p>I want the format to be more like this – ‘02-12-2014 04:19:00’</p>
  
  <p>Any ideas if this is possible ?</p>