OraFAQ Forum: SQL & PL/SQL » How to Extract Month from date column.

Home » SQL & PL/SQL » SQL & PL/SQL » How to Extract Month from date column.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to Extract Month from date column. [message #114710]

Tue, 05 April 2005 05:21

weekend79
Messages: 198
Registered: April 2005
Location: Islamabad

Senior Member

suppose

Date_Column
12-MAR-2000
16-APR-2005
04-JUN-2004

I want a quire which result.
MARCH
APRIL
JUNE

Wishes
Jawad

Report message to a moderator

Re: How to Extract Month from date column. [message #114711 is a reply to message #114710]

Tue, 05 April 2005 05:25

pstanand
Messages: 133
Registered: February 2005
Location: Chennai,India

Senior Member

Hi use this. You will get the month name.
SELECT TO_CHAR(DATE_COLUMN,'MONTH')FROM <TABLE NAME>

Regards
pstanand

Report message to a moderator

Re: How to Extract Month from date column. [message #114713 is a reply to message #114710]

Tue, 05 April 2005 05:30

Barbara Boehmer
Messages: 9106
Registered: November 2002
Location: California, USA

Senior Member

scott@ORA92> column month format a5
scott@ORA92> select hiredate, to_char (hiredate, 'MON') as month from emp;

HIREDATE  MONTH
--------- -----
17-DEC-80 DEC
20-FEB-81 FEB
22-FEB-81 FEB
02-APR-81 APR
28-SEP-81 SEP
01-MAY-81 MAY
09-JUN-81 JUN
09-DEC-82 DEC
17-NOV-81 NOV
08-SEP-81 SEP
12-JAN-83 JAN
03-DEC-81 DEC
03-DEC-81 DEC
23-JAN-82 JAN

14 rows selected.

Report message to a moderator