It Seems That Someone Has Deleted That Topic Since I Found The Url Of The Topic But It Gives Me An Error
SELECT birth FROM "tablename" WHERE birth BETWEEN '2005/02/01' AND '2005/03/15'
-reply by vrutika shah
| |
|
Welcome to AstaHost - Dear Guest 
, Please Register here to get Your own website. - Ask a Question / Express Opinion / Reply
w/o Sign-Up!
| |
Toggle shoutbox
Shoutbox
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Replying to Help: SQL For Returning Data Between Dates
Topic Summary
jvizueta
Posted 22 September 2005 - 11:44 PM
I have a data base that possesss a field BIRTH. How I make a research that returns me all the aniversariantes in definitive period? example: 01/02/2005 - 15/03/2005.
Try this:
Select * from orders Where orderdate >='19970805' and orderdate <
dateadd(dd,1,'19970805')
or this methods from sql:
DateTime
SamallDateTime
Houdini
Posted 14 August 2005 - 06:05 PM
It would help if you at least showed us the database structure because fields are in tables and tables are in databases then you would know how to write a query to retrieve the table data (one particular field in this case) and after obtaining that data running a PHP script which would filter out the wanted or unwanted data here is and example of just a small table
As you can see above all in single quotes are fields within a table called authors so from the limited information you gave it would be almost impossible to help someone answer your question.
CREATE TABLE `authors` ( `aid` varchar(25) collate latin1_general_ci NOT NULL default '', `name` varchar(50) collate latin1_general_ci default NULL, `url` varchar(255) collate latin1_general_ci NOT NULL default '', `email` varchar(255) collate latin1_general_ci NOT NULL default '', `pwd` varchar(40) collate latin1_general_ci default NULL, `counter` int(11) NOT NULL default '0', `radminsuper` tinyint(1) NOT NULL default '1', `admlanguage` varchar(30) collate latin1_general_ci NOT NULL default '', PRIMARY KEY (`aid`), KEY `aid` (`aid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
As you can see above all in single quotes are fields within a table called authors so from the limited information you gave it would be almost impossible to help someone answer your question.
