sql query to get data between two dates

[ciba]

Hi
I want to retrieve values from table tbl_abc
where the
value of StartTime (the column in tbl_abc)

falls between these two time

2009-07-15 09:57:24.0
2009-07-15 09:58:24.0

[davey23uk]

so whats the problem?

[ciba]

I need to write an SQL query for the same ..

I am ableto retrive values between two dates '2009-07-15' and '2009-07-16' but
not when the two dates are same but time is different....

select * from tbl_abc where trunc(StartTime) between to_date('2009-07-15', 'YYYY-MM-DD') and to_date('2009-07-16', 'YYYY-MM-DD');

but this will not work for same dates ....

[davey23uk]

well you have added trunc which strips off the time part

[gandolf989]

If you subtract one date from another you will get the time difference in days.
Then multiply by 24 and you will get the time difference in hours, etc.

SYS AS SYSDBA> select (sysdate-(sysdate-5/24))*24 from dual;

(SYSDATE-(SYSDATE-5/24))*24
---------------------------
5