title: Handling time using PostgreSQL
body: <p>I have a table with a <code>date</code> and <code>time</code> field. I'm having difficulty understanding how I deal with this, partially as I don't understand how time can be converted to a number. I made a table using the following command:</p>
  
  <pre><code>CREATE TABLE tracking.time_record
  (
    date date, 
    "time" time without time zone,
    id character(100)
  )
  </code></pre>
  
  <p>An example of my data is as follows:</p>
  
  <pre><code>"2012-04-18" | "18:33:19.612" | "2342342384" 
  </code></pre>
  
  <p>How can I run a query such that I can examine all of the <code>id</code> values that have a time value <code>&gt; 10 pm</code> on a certain day, for example?</p>
  
  <p>I realize that as my time is stored in a character type  variable so something like this does not work:</p>
  
  <pre><code>SELECT * FROM tracking.time_record 
  WHERE "time" &gt; "04:33:38.884" AND date &gt; "2012-04-18"
  </code></pre>
  
  <p>(This is my first exploration of time/date tracking - I should probably have chosen different column names)</p>