garry27 Posted October 31, 2008 Share Posted October 31, 2008 I'm trying to get a result set for all records with date set to the current month by using a LIKE clause. Unfortunately, it returns a 0 result set. Without the LIKE clause the code works as expected. "SELECT GA_Gig.gigID, GA_Gig.date, GA_User.stageName, GA_Venue.venue, GA_Town.town, GA_Gig.startTime, GA_Gig.endTime, GA_Gig.musicType, GA_Gig.entryFee, GA_Gig.gigNote FROM GA_Gig, GA_Town, GA_Venue, GA_User WHERE GA_Gig.date LIKE '2008-10-%' AND GA_Gig.townID = GA_Town.townID AND GA_Gig.venueID = GA_Venue.venueID AND GA_Gig.userEmail = GA_User.userEmail AND GA_Town.region = 'North East' ORDER BY date " Any advice please? Quote Link to comment Share on other sites More sharing options...
Barand Posted October 31, 2008 Share Posted October 31, 2008 try WHERE DATE_FORMAT(GA_Gig.date, '%Y-%m') = '2008-10' Quote Link to comment Share on other sites More sharing options...
fenway Posted November 3, 2008 Share Posted November 3, 2008 Or EXTRACT(YEAR_MONTH FROM GA_Gig.date) = '200810' Quote Link to comment 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.