PHP Date range query
Posted: Thu Dec 03, 2009 12:25 pm
So I have an existing database system that is using the date for customer records in a TEXT format. The format being used is:
MM/DD/YYYY
What I am wanting to do is finish my reporting system but need to query records in a MySQL query between a date range.
What is the most effective way to do this without changing the entire database and the thousands of records?
Rephrase, I basically want a query to select X number of records if their date is between start date MM/DD/YYYY and end date MM/DD/YYYY.
Thoughts?
Thanks in advance.
MM/DD/YYYY
What I am wanting to do is finish my reporting system but need to query records in a MySQL query between a date range.
What is the most effective way to do this without changing the entire database and the thousands of records?
Rephrase, I basically want a query to select X number of records if their date is between start date MM/DD/YYYY and end date MM/DD/YYYY.
Thoughts?
Thanks in advance.