0 points

php - Get MySQL database entries within last week - Stack Overflow


dashboard

Sun Jun 21 2020 13:31:54 GMT+0000 (UTC)

Posted by @peota #mys #php

SELECT * FROM tableName WHERE timeColumn > UNIX_TIMESTAMP( date_sub(now(),interval 1 week)) and UserName = 'givenUserName'
content_copy Copy

https://stackoverflow.com/questions/9632392/get-mysql-database-entries-within-last-week