SQL: field value based on condition?
===

I am going to need to return a special value to tell me if the current time is within opening hours:

In table **places**  

    ID    OPEN     CLOSE  
    1     14:00    16:00  
    2     12:00    15:00
    3     10:00    14:00

I need to return in the query a special field: PLACE_IS_OPEN - true or false.

so that the returned result when the time is `14:35` is:

    ID      PLACE_IS_OPEN
    1       1
    2       1
    3       0

What would be a descent way to go about this?
