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...?? Quote 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) Quote Link to comment https://forums.phpfreaks.com/topic/83145-solved-query-date/#findComment-422909 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.