I want to count the number of Sundays occurring in a given date range using MySQL... My problem is the dates given is not in a table...all I want is to let SQL compute it without any query..for example: SELECT DATEDIFF(date1,date2); which of course doesn't need any tables to query. Is it possible?I want to count the number of Sundays occurring