Training, Open Source
computer languages

Perl • PHP • Python • MySQL • Apache / Tomcat • Tcl • Ruby • Java • C and C++ • Linux • CSS 

Search our site for:
Print friendly page
Home Accessibility Courses Diary The Mouth Forum Resources Site Map About Us Contact
extracting record based on time.

Posted by shrii2006 (shrii2006), 15 May 2008
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.


This page is a thread posted to the opentalk forum at www.opentalk.org.uk and archived here for reference. To jump to the archive index please follow this link.
Course Booking
Subject:
Other Forum Posts
extracting record based on time.
password only for a specific database
Select records from March
Variable length MYSQL result
MySQLand HTML
using php and mysql to provide a image library
spot the problem.....
Link tables from two data files
creating relation between tables?
Location of SQL files for submittion through...
A Really easy project, but need help
Image Library - Upload works but image missing?
how to build forum
MYSQL and APACHE on local computer
Using PHP and MySQL to provide an image library
Data truncated for column 'sale_price' at row 1
PHP script, mysqli functions update a record
THREE WAY JOINS with subqueries & groups
Edit Script not working
Looking for a PHP/MySQL programmer to work with
a comma
4 characters in mysql
How to Rename database
2003 Error cannot connect to MySQL on Win XP Home
accessing a mysql server version 4.1.16
Regular Automatic backups of a database.
MySQL  question
select where statement
Joining a table to itself
Programmatically or SQLlly?
using the right tools?
mysql_fetch_array(): argument is not a valid
Images in MySQL
How to get rid of duplicate data??
Upgrade to MySQL 5.0 - PHP,QT,Python Libs
Problem Inserting Data into Table
Moved: Email Notification
Batch Processing ?
Aliases in Update
Query A Different Database?
Linking Tables Foreign key
Multiple users and data integrity
LEFT JOIN
Finding the key of a row just added
Upgrading to MySQL 4.1 - a caution
Using foreign Keys
MySQL Resources
Holding config data in a table
MySQL as Case Sensitive
count even or odd objects
SQL Injection Attacks
MyIsam or InnoDB with small database
Mysql installation & configuration
Mirror database - low bandwidth
only 1000 records in mysql
Database Modelling in UML
Long character string in a WHERE clause filter?
Advantages and disvantages of MySQL
Mysql Full-Text Search
Using ASP with MySQL
Moved: Looking for a script in PHP
mysqldump and deleting table contents
SQL_BUFFER_RESULT
limit table to 1 record
insert into using result of a select
insert and select datetime in GMT timezone
Update syntax
Copying a table structure
Error 1148
MySQL / Java / PreparedStatement Quoting
Limiting number of rows in table
Transform / Pivot tables?
My root account is messed up - what can I do?
Mysql Regex question
Loading a table from data in a text file
Producing a list of names
mySQL over a Beowulf cluster
mysql dump into a text file
Starting mysqld on boot - OSX
making mysql secure
Changing column values
MySQL query to a text file
how to load text file into largetext field?
On limiting selection
loop problem
How does this work?
store file names or store files themselves?
is there any way to do this?
help.  how to transfer data to remote mysql db?
help.  how to config remote mysql db?
Creating a table with MySQL
Invoking MySQL from the C:\> Promt in Windows 2000
Foreign Keys - steps to enable
Error upon Attempt to Connect
Entering foreign keys into main table
User enetering data into MySQL - 2 tables
MySQL/localhost problems
Does a table exist? Oracle and MySQL check
write to db
web based table editing
creating relationships
timestamp name
linking tables???
convert php / mysql page to html
Data becoming corrupted
cannot connect to the db via an ASP page
error message
MYSQL + tool to build report's
Cannot connect to server
Joining tables
Views, triggers etc in MySQL?
jbuilder8 and mysql need help badly
error message...don't know why
what database should I use?
Microsoft Excel to Mysql
mysql tables on raw partition
How to write an INNER JOIN QUERY in Mysql
Char, Varchar or Text?
date comparisons in sql
Subtraction one set from anothe set in MySQL
How to write this query
Different versions and importing a text file
Tcp port v named socket / Multiple mysqld servers
The Dolphin gets a name!
Finding out about columns
Import Data from MS Access
Are MySQL enquiries case sensitive?
soundex clause
Printed Reference manual
What is MySQL-MAX?
Try out your MySQL ...
WELL HOUSE CONSULTANTS LTD.: Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 01144 1225 708225 • FAX: 01144 1225 707126 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho