title: Construct DateTime using today's date at a specific time
body: <p>I'd like to get 4:30 PM of the current day. Hard-coding this way doesn't work:</p>
  
  <pre><code>SELECT '07242012 16:30:00.000'
  </code></pre>
  
  <p>This is proving to be more difficult than I thought it would be. How do I approach this?</p>