Wrox Programmer Forums
Go Back   Wrox Programmer Forums > PHP/MySQL > MySQL
|
MySQL General discussion about the MySQL database.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the MySQL section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 23rd, 2004, 04:32 AM
Registered User
 
Join Date: Aug 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default How to select a time that is within a interval?

Hi!

If i have a time and date i an database and want to check if that time and date are within a specified time interval

like if 2004-08-23 11:00 is within 2004-80-22:11:00 -> 2004-08-24 10:00

how do i do this?

 
Old August 23rd, 2004, 05:58 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Use Between operator to check that.
Code:
Select ColumnName from TableName where DateColumnName BETWEEN '2004-80-22:11:00' AND '2004-08-24 10:00'
Cheers!

_________________________
- Vijay G
Strive for Perfection
 
Old August 23rd, 2004, 06:33 AM
Registered User
 
Join Date: Aug 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thank you
It works perfect






Similar Threads
Thread Thread Starter Forum Replies Last Post
Help to query for data by 30-mins interval sunny76 Access 2 June 19th, 2008 11:52 AM
how to run code snippet in regular interval Swati Chari Beginning VB 6 2 March 12th, 2008 03:07 PM
tooltip interval??? nerssi HTML Code Clinic 5 August 4th, 2006 12:05 AM
User date and time select and pass to query newbe Access 2 December 16th, 2005 08:59 AM
A date interval with a date interval query spinto SQL Server 2000 7 May 15th, 2004 04:26 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.