Why is this query not working in android SQLite

SELECT * FROM EVENT_total_time 
WHERE USER_ID = 2 
    AND LEVEL_SEQUENCE_NUMBER = 1 
    AND DATETIME( TIMESTAMP ) BETWEEN DATETIME('now','-7 days') AND DATETIME('now') 
ORDER BY datetime( TIMESTAMP ) ASC

and the DB has

PRINTING TABLE EVENT_total_time
0 {
    _id=56
    USER_ID=2
    TIMESTAMP=2016-02-15 21:29:29
    EPOCH_TIME=1455571769621
    NEW_VALUE=3.034
    LEVEL_ID=7
    LEVEL_SEQUENCE_NUMBER=1
    EXTRAS={"old_value":0}
  }
1 {
    _id=57
    USER_ID=2
    TIMESTAMP=2016-02-15 21:29:29
    EPOCH_TIME=1455571769822
    NEW_VALUE=3.219
    LEVEL_ID=7
    LEVEL_SEQUENCE_NUMBER=1
    EXTRAS={"old_value":3.034}
  }

this query was ran 30sec ago so ... datetime('now') should be 15.02.2016 21:32:00 ....

Please help

Thank you