--- In firebird-support@yahoogroups.com, "ehaerim" <ehaerim@...> wrote:

>
> 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.
>
> Can someone change this correctly please?
>
> thx
> HR
>

This may or may not be useful, depending on the exact data types being used. Note the 00:00 + 23:59 additions to the D tests:

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