Creating a select statement for working with dates

[mrw2020]

Hi, I'm trying to create a 'select' statement that picks a date from a database that is 358 days old - does anyone have an idea how to do this?

I have a table called invoice with the following fields

id(int, auto increment), due(DATE), email(varchar), company(varchar), name(varchar), cost(decimal 10,2)

the statement I have so far is:

$query = "SELECT price, due, email, company, name FROM invoice WHERE due="; // selecting information from db
$result = mysql_query($query); // getting the results of the query
if (!$result) {
	echo 'could not run query: ' . mysql_error();
	exit;
	}

and I'm just not sure what the proper way of writing it is, any help would be greatly appreciated.

[mrw2020]

I've updated the statement as follows:

$query = "SELECT price, due, email, company, name FROM invoice WHERE DAYOFYEAR(due) > 356 AND < 358"; // selecting information from db
$result = mysql_query($query); // getting the results of the query
if (!$result) {
	echo 'could not run query: ' . mysql_error();
	exit;
	}

I'm sure it can't be as simple as that, could someone look at the code and put me in the right direction?

Many thanks

[sunnyil]

hi you can do something like this.

select now() - interval 358 day;

[sneakyimp]

Actually i think it would be:

SELECT price, due, email, company, name FROM invoice WHERE due < DATE_SUB(NOW(), INTERVAL 358 DAY);

if you want to find out what date is 358 days ago:

SELECT DATE_SUB(NOW(), INTERVAL 358 DAY);

I don't think DAYOFYEAR does what you want. I think your query is going to select any records where due is december 23, regardless of what year.

[mrw2020]

Many thanks for all your help, I'll give that a go.