[thomas_w]

also bei mir geht's

INSERT INTO occupancy VALUES
(1, 1, 6 , DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 4 HOUR), CURRENT_TIMESTAMP );


mysql> select * from occupancy;
+----+---------+----------------+---------------------+---------------------+
| id | user_id | workstation_id | start               | end                 |
+----+---------+----------------+---------------------+---------------------+
|  1 |       1 |              6 | 2011-04-23 15:50:47 | 2011-04-23 19:50:47 |
+----+---------+----------------+---------------------+---------------------+
1 row in set (0.00 sec)

mysql>


SELECT * FROM occupancy
 WHERE user_id = 1
   AND start >= '2011-04-23 15:50:47'
   AND end <= '2011-04-23 19:50:47';
+----+---------+----------------+---------------------+---------------------+
| id | user_id | workstation_id | start               | end                 |
+----+---------+----------------+---------------------+---------------------+
|  1 |       1 |              6 | 2011-04-23 15:50:47 | 2011-04-23 19:50:47 |
+----+---------+----------------+---------------------+---------------------+
1 row in set (0.01 sec)

mysql>

Grüße
Thomas