title: sybase check if a datetime is within time
body: <p>I have a column with datetime as the data type</p>
  
  <p>I need to check if that datetime column is between 2:30pm to 3pm, "ignoring" the date</p>
  
  <p>I saw an example in sql server that cast the datetime to float but that did not work in sybase...</p>
  
  <p>does anyone have any idea</p>
  
  <p>thanks</p>