i want to find a month from the table tableX which contains full_date, last_name ect...
full_date's format is like this : "1987.06.17 00:00:00"
now, i write a query like this,
SELECT full_date FROM tableX WHERE full_date LIKE '_____06%' this is works for JUNE's..
But i want to write a query like this SELECT full_date FROM tableX WHERE full_date LIKE 'JUNE' ;
how can ?