Sql Finding Month of Date

use the month function
SELECT full_date FROM tableX  WHERE month(full_date) = 6

assume your full_date is of  VARCHAR2 type,

SELECT full_date from tableX where
to_char(to_date(full_date, 'YYYY.MM.DD HH24:MI:SS'), 'MM') = '06';

can not use 'June', instead of integers. without using integer 06, i want to use JUNE word in the query..

Or a more simpler way:

SELECT full_date from tableX where
extract ( month from to_date(full_date, 'YYYY.MM.DD HH24:MI:SS')) = 6;

If you insist to use JUNE keyword,
here is what you can do:

SELECT full_date from tableX where
to_char(to_date(full_date, 'YYYY.MM.DD HH24:MI:SS'), 'MONTH') = 'JUNE';

Sorry forgot to trim the space:

SELECT full_date from tableX where
trim(to_char(to_date(full_date, 'YYYY.MM.DD HH24:MI:SS'), 'MONTH')) = 'JUNE'

should it work for this format "1987.06.17 00:00:00" .. full_date's entry is like this.Becuse it is not working. i am just trying, may there is no solution for this.

may be it will work if the entry of full_Date is like this "1987.JUNE.17 00:00:00" but know it is not working for 1987.06.17 00:00:00.. but there is no compilation fault.

what is the data type for your field (full_Date) ?

assuming that it is indeed datetime (or timestamp), a simplified version of pkwan's suggestion should work:
SELECT full_date from tableX
where to_char(full_date, 'MONTH') LIKE 'JUNE%'

if it's varchar, a minor change to pkwan's code should work:
SELECT full_date from tableX
where to_char(to_date(full_date, 'YYYY.MM.DD HH24:MI:SS'), 'MONTH') LIKE 'JUNE%'

full_date is DATE.. data type..

table is like this,

full_date
1987.06.17 00:00:00
1994.02.17 00:00:00
1998.03.19 00:00:00

maybe there is no sql query to do this. i just create a problem to solve it :) really it is not a problem also.

i may write

SELECT full_date FROM tableX  WHERE full_date LIKE  '_____06%'
or
SELECT full_date FROM tableX  WHERE month(full_date) = 6

instead of writing JULY in query... :(

okk.. i got.. thanks.