Hi,

I am having a column in table which is storing date in the form of seconds since 01/01/1970.

I just want to write a query to check time of records if they fall between 8:00AM and 11:00AM

Can anybody pls. help me write a SQL(ORACLE) query for this.

really appreciate any help

thanks
Ajay