title: Postgresql, comparing text as datetime
body: <p>I have a table with two columns of "text" type where in one is a date in format 10.03.2013. and in second is time in format 15:45:32. Since both are text I would like to know if is possible with PostgreSQL those strings compare with windows DateTime value.</p>
  
  <p>I was try to get records with BETWEEN() but didn't get nothing.</p>
  
  <pre><code>"(mydate BETWEEN " &amp; fromdate.Date.ToString &amp; _
         " AND " &amp; todate.Date.ToString &amp; ") AND _
   (mytime BETWEEN " &amp; fromdate.TimeOfDay.ToString &amp; _
         " AND " &amp; todate.TimeOfDay.ToString &amp; ")"
  </code></pre>
  
  <p>mydate and mytime are columns while fromdate and to date are windows datetime types.  </p>
  
  <p>Any advice?</p>