crashmaster Posted December 25, 2007 Share Posted December 25, 2007 Hi there, I have a db table (users) which has column "birthday_date" (format DATE: YYYY-MM-DD) I need to make a sql query to get from database all users who are older than 18 ... How can I do it...?? Link to comment https://forums.phpfreaks.com/topic/83145-solved-query-date/ Share on other sites More sharing options...
pocobueno1388 Posted December 25, 2007 Share Posted December 25, 2007 Try SELECT user FROM users WHERE birthday_date > (NOW() - INTERVAL 18 YEAR) Link to comment https://forums.phpfreaks.com/topic/83145-solved-query-date/#findComment-422909 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.