title: Oracle/Smarteam - How do I interpret a Date/Time value held as a number value
body: <p>This is my first question on this so please feel free to correct me if I haven't put it in the correct format etc.</p>
  
  <p>I have been asked to extract some metrics from our engineering product management system Smarteam. As a little bit of background Smarteam is a PDM product made by Dassault that stores engineering data in a back end database which in our case is Oracle 11g.</p>
  
  <p>The metrics I'm trying to gather are time related metrics to do with the length of time each person takes as a drawing passes through a flow (release) process.  </p>
  
  <p>This is for the most part straight forward SQL queries. E.g.:</p>
  
  <pre><code>select OBJECT_ID, TDM_NAME, CREATION_DATE, TDM_END_TIME
  from tdm_sf_process
  where tdm_name = 'XXXX'
  </code></pre>
  
  <p>This gets me the start and end times for a flow process.</p>
  
  <p>I am however having a problem interpreting a time value held in one of the tables.  The table <code>TDM_SF_PRC_HISTORY</code> contains a column called <code>TDM_ACTUAL_TIME</code> with a data type <code>NUMBER</code>.  The numbers held in this column take the format <code>0.000240601853874978</code>.</p>
  
  <p>Can someone please tell me how one would go about converting this value to a useful date/time. It is probably something quite straightforward but it is not something I've come across before in my limited Oracle db experience.</p>
  
  <p>Many Thanks</p>