CREATE TABLE T_10199000(D DATE NOT NULL, T TIME NOT NULL, P DOUBLE PRECISION NOT NULL, V FLOAT NOT NULL, PRIMARY KEY (D, T), CHECK(V >= 0))

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