title: Firebird check if date is before 12 pm of the current day
body: <p>Date calculations are not my strong point and I need a little help.
  I'm trying to check if a date (which is a timestamp) from a selected field is before 12pm of the current day. Thanks in advance.</p>
  
  <p>Scenario: if an order is placed before 12pm that day, it will qualify for x otherwise it gets y. So my create date (including time) of that order is what I get in my select statement.</p>