Sql Query

General discussion on technical and managerial topics
no avatar
SIVA1515
 
Posts: 1
Joined: Tue Jun 26, 2012 8:36 pm
Location: CHENNAI

Sql Query

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

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 ....

no avatar
dhanireddy
 
Posts: 1
Joined: Wed Sep 05, 2012 11:44 am

AQL

by dhanireddy » Wed Sep 05, 2012 11:52 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>

Return to General Discussion