Javascript Disabled Detected

You currently have javascript disabled. Several functions may not work. Please re-enable javascript to access full functionality.


Welcome to AstaHost - Dear Guest , Please Register here to get Your own website. - Ask a Question / Express Opinion / Reply w/o Sign-Up!

Replying to Help: SQL For Returning Data Between Dates

Post Options

Enable emoticons?

Enter Your Name

Security Check *

[quote name="WeaponX" post="48486" timestamp="1124040561"] I'm not very good at SQL but I think I found what you want. I remember reading about this when I was curious on how SQL works and found the a short tutorial at [url="http://www.w3schools.com/sql/sql_where.asp"]W3Schools[/url].[/quote] [quote name="WeaponX" post="48486" timestamp="1124040561"] I'm not very good at SQL but I think I found what you want. I remember reading about this when I was curious on how SQL works and found the a short tutorial at [url="http://www.w3schools.com/sql/sql_where.asp"]W3Schools[/url].[/quote]

or Cancel

Topic Summary

Posted 02 February 2009 - 06:28 AM

SELECT birth FROM "tablename" WHERE birth BETWEEN '2005/02/01' AND '2005/03/15'

-reply by vrutika shah

Posted 29 May 2008 - 02:46 PM

sql queries for retriving dates between the given dates from the same table
Help: SQL For Returning Data Between Dates

Sql queries for retriving dates between the given dates from the same table
For example
05/13/2008 to 05/26/2008
I want to retrive the dates from a tables between those days...

-reply by sujai

Houdini

Posted 15 October 2005 - 03:47 AM

Have you tried the below:

SELECT birth FROM "tablename" WHERE birth BETWEEN 2005/02/01 AND 2005/03/15

You will notice that I have rearranged the dates because MySQL expects the dates to be entered YYYY-MM-DD and from the post it look like you had expressed it as Feburary the first 2005 and March the 15th 2005.

So since that is how MySql stores dates as shown above then that would be how you have to query it to get the response you would want.

Also I used "tablename" since I have no clue as to what table the field birth would be in, but you should know what to substitute for it.

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

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.

WeaponX

Posted 14 August 2005 - 05:29 PM

I'm not very good at SQL but I think I found what you want. I remember reading about this when I was curious on how SQL works and found the a short tutorial at W3Schools.

fabiocardoso

Posted 14 August 2005 - 10:10 AM

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.

Review the complete topic (launches new window)