ocean base OB
SELECT
date_diff('second', '2010-11-30 23:59:59', '2010-11-30 23:58:59'),
50<date_diff('second', '2010-11-30 23:59:59', '2010-11-30 23:58:59'),
date_diff('second', '2010-11-30 23:59:59', '2010-11-30 23:58:59')>50,
50<date_diff('second', '2010-11-30 23:59:59', '2010-11-30 23:58:59')<70,
100<date_diff('second', '2010-11-30 23:59:59', '2010-11-30 23:58:59')<70
;
SELECT 100<10<20;