| Subject | SELECT returns no data |
|---|---|
| Author | ehaerim |
| Post date | 2011-05-30T21:19:42Z |
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
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