title: Microseconds in timestamp : db2 query
body: <p>I want microseconds in timestamp so I am using below query but not getting the microseconds</p>
  
  <pre><code>select TIMESTAMP_FORMAT(CURRENT_TIMESTAMP,
         'YYYY-MM-DD HH:MM:SS.NNNNNN') FROM SYSIBM.SYSDUMMY1
  </code></pre>
  
  <p>Getting : <code>2013-06-01 02:45:12</code>
  Expected output:<code>2013-06-01 02:45:12.145235</code></p>
  
  <p>Ref:<a href="http://pic.dhe.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2z9.doc.sqlref%2Fsrc%2Ftpc%2Fdb2z_bif_timestampformat.htm" rel="nofollow">http://pic.dhe.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2z9.doc.sqlref%2Fsrc%2Ftpc%2Fdb2z_bif_timestampformat.htm</a></p>