Help with mysql date functions

[pwrlogic]

Hi
This should be easy
all i want to do is select all the records in a table greater than three days old.
select * from tableA where tablea.timestmp < current_timestamp - 3; does not work.
i'm stumped.

 

[sleipnir214]

Try:

where unix_timestamp(now()) - unix_timestamp(fieldname) > 259200


Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[pwrlogic]

hi
thanks for the input
i found the solution though i do not know if it will work in both php and java sqlj/jdbc

SELECT *
FROM shopping_cart
where shopping_cart.timestmp
<= DATE_SUB(CURRENT_TIMESTAMP, INTERVAL &quot;3&quot; DAY)
order by shopping_cart.timestmp desc;
it works perfect.