Selecting today Placed loan and cleared loan in provided table : I am building an application that hold user loan information; but the problem is how to select amount of loan placed today and cleared today; for example if user place loan at 7:00 AM and cleared it at the same day at 13:00 PM how could I get this loan placed today and cleared today? My example table is:

    --------------------------------------------------------------------------
    id | user_id | placed_loan | cleared loan | plcd date | cld_date | status
    --------------------------------------------------------------------------
    1  |   2     |   5000.00   |    0.00      |  19/6/12 |          |   1 
    -------------------------------------------------------------------------- 
    2  |   2     |   0.00      |    4000.00   |          |  19/6/13 |   2 
    -------------------------------------------------------------------------- 
    3  |   2     |   2000.00   |    0.00      |  19/6/14 |          |   1 
    -------------------------------------------------------------------------- 
    4  |   3     |   4000.00   |    0.00      |  19/6/14 |          |   1 
    -------------------------------------------------------------------------- 
    5  |   2     |   0.00      |    3000.00   |          | 19/6/14  |   2 
    -------------------------------------------------------------------------- 
    6  |   3     |   0.00      |    2000.00   |          | 19/6/15  |   2 
    -------------------------------------------------------------------------- 

For example user with ID 2 on 19/6/14 placed a loan of 2000.00 and cleared a loan of 3000.00 this is to say that amount of loan placed on 19/6/14 and cleared on 19/6/14 for the user 2 is 2000.00; and remaining 1000.00 was of 19/6/12. how could I select these data?