Can you supply the structure of the table?

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