MySQL – gdje je datum stariji od x dana

Problem:

Selektirati iz baze sve redove gdje je datum stariji od npr. 30 dana

Rješenje:


SELECT FROM tablica WHERE datum < DATE_SUB(NOW(), INTERVAL 30 DAY);

 

This entry was posted on Tuesday, April 8th, 2014 at 2:17 pmand is filed under MYSQL Database Development. You can follow any responses to this entry through the RSS 2.0 feed. Responses are currently closed, but you can trackback from your own site.

Comments are closed.