Advertisements

Sql Query

Postby SIVA1515 » Tue Jun 26, 2012 8:41 pm

Offline
SIVA1515
Posts: 1
Joined: Tue Jun 26, 2012 8:36 pm
Location: CHENNAI
My requirement ..Two dates in my form ..

One is : 15-JAN-2012
sECOND : 20-AUG-2012

I need Output :
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG

Month name only ..
How can i write the Sql ..

Please help me ....

AQL

Postby dhanireddy » Wed Sep 05, 2012 11:52 am

Offline
dhanireddy
Posts: 1
Joined: Wed Sep 05, 2012 11:44 am
SELECT to_char(date, 'MON') from table; would work

for more sql queries visit <a href="http://www.techsamples.com">www.techsamples.com</a>