title: Is there any way convert text to time in postgresql?
body: <p>Is there any way convert text to time type?
  Code in postgresql as below:</p>
  
  <pre><code>to_char(localtimestamp(0),'HH24:mi:SS')
  </code></pre>
  
  <p>this way I will get the value like <code>15:15:20</code>,but this <code>type</code> is varchar(or text).<br>
  How can I do to get the value in <code>time</code> type?</p>
  
  <p>Thanks!</p>