I have created a table which stores IP address, browser,  time of access, OS and a unique ID for each record.  I want to retrieve the records based on a time range like from 0-6 hrs, 6-12 hrs , 12-18 hrs and 18-24 hrs for a given date.. I would like to know what query can be used for this.

on 05/15/08 at 07:18:25, shrii2006 wrote:

I have created a table which stores IP address, browser,  time of access, OS and a unique ID for each record.  I want to retrieve the records based on a time range like from 0-6 hrs, 6-12 hrs , 12-18 hrs and 18-24 hrs for a given date.. I would like to know what query can be used for this.

Hello,

Just wanted to ask some thing about your table. Do you have separate two column for Date & Time or only One column.

If you have two column Then you can write it like
Select * from <table_name> order by time,date ASC;

If you have   ONE column that conain both date& time then you can use
Select * from <table_name> order by DATETIME ASC;

Thanks
Sam

---