<div>
45 days old from the current date....
</div>


<div>
Try this<br />
SELECT * FROM currsale WHERE (DATEDIFF(CURDATE(),tranda<wbr />te) &gt;&nbsp;45)
</div>


Try this
SELECT * FROM currsale WHERE (DATEDIFF(CURDATE(),trandate) > 45)

<div>
You could do:<br />
<br />
SELECT * FROM table WHERE acocmp1.currsale.trandate &gt;&nbsp;DATE_SUB(NOW(),INTERVAL 45 DAY)
</div>


You could do:

SELECT * FROM table WHERE acocmp1.currsale.trandate > DATE_SUB(NOW(),INTERVAL 45 DAY)

<div>
<div class="content wysiwyg-content">
Hi All,<br />
I am trying to create an sql select where query that will return all records that are 45 days old.<br />
<br />
My date field is acocmp1.currsale.trandate<br />
<br />
The current format for the date in that field is 2102-01-03 00:00:00<br />
<br />
Cheers
</div>
</div>


Hi All,
I am trying to create an sql select where query that will return all records that are 45 days old.

My date field is acocmp1.currsale.trandate

The current format for the date in that field is 2102-01-03 00:00:00

Cheers

SQL Select all records 30 days prior

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.