title: how to get the time from timestamp without time zone data type of parameter in postgreSQL
body: <p>HI i have a 2 parameters which is timestamp without time zone data type, i am calculating the these 2 parameter clock_out_time  and clock_in_time</p>
  <p>here is my function</p>
  <pre><code>(select EXTRACT ( hour from (select sum( att.clock_out_time - att.clock_in_time) 
              from public.&quot;VOfficeApp_employee_attendence&quot; att
              where att.user_id = 2017
              and att.company_id =391 
              and date_part('month', date) = 4)))
  </code></pre>
  <p>OUTPUT:
  &quot;24&quot;
  WHAT I AM LOOKING FOR:
  &quot;24:38:30.084&quot;</p>
  <p>Actually i have to convert this days to  time how can i convert</p>
  <pre><code>29 days 24:38:30.084
  </code></pre>