HR,

> I want to select data from '2011-05-29 15:00:00.0001' to '2011-05-30
> 14:59:59.9999'.
>
> SELECT D, T, P, V FROM T_10199000 WHERE D >= '2011-05-29' AND T >=
> '15:00:00.0001' AND D <= '2011-05-30' AND T <= '14:59:59.9999' ORDER BY D, T
> ASC;
>
> Apparently the above statment didn't work.

SELECT
D, T, P, V
FROM T_10199000
WHERE
(D >= '2011-05-29' AND T >= '15:00:00.0001')
AND
(D <= '2011-05-30' AND T <= '14:59:59.9999')
ORDER BY D, T ASC;