thx for the prompt reply.
but it didn't return any data, either.
I confirmed there existed data by

SQL> SELECT D, T, P, V FROM T_10199000 WHERE D <= '2011-05-30' AND T='00:00:00:0001';

D T P V
=========== ============= ======================= ==============
2011-05-30 00:00:00.0001 279.2000122070313 6050.0000
2011-05-27 00:00:00.0001 275.2500000000000 659.00000

SQL>

Would you check again please?
thx

--- In firebird-support@yahoogroups.com, "Leyne, Sean" <Sean@...> wrote:
>
> 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;
>