OraFAQ Forum: Forms » Help Need In Query

Home » Developer & Programmer » Forms » Help Need In Query

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

Help Need In Query [message #78908]

Thu, 28 March 2002 19:15

annu
Messages: 34
Registered: February 2002

Member

Dear Experts,

Anybudy tell me how i make the query for the fixed facical year. while i have just Nmonth varchar2(2) and Nyear varchar2(4) in column of my table .. and the data suppose i want to extract between 07/99 to 06/00. Note here the data stored in table is b/w 06/88 --- 03/02. The data stored in table just like as follows ,,,,

Nmonth..........Nyear
07..............1999
08..............1999
09..............1999
10..............1999
11..............1999
12..............1999
01..............2000
02..............2000
and so on .........

Annu

Report message to a moderator

Re: Help Need In Query [message #78911 is a reply to message #78908]

Fri, 29 March 2002 20:25

rama krishna
Messages: 97
Registered: December 2001

Member

try this

select to_date(to_number(Nmonth)||'-'||to_number(Nyear),'mm-yyyy') from your_table

but there is a problem with this. it will always return first day of the month. so if u want to check between days ithink u need to write a pl/sql procedure.....

any queries u can mail me back...

cheers
ram

Report message to a moderator

Re: Help Need In Query [message #78935 is a reply to message #78908]

Thu, 04 April 2002 00:00

Ayan
Messages: 11
Registered: February 2002

Junior Member

Hi

select data between nyear||nmonth. So 200006 will always be greater than 199907 as well as 200005 and will be less than 200007. leave it in character format.

Hope this will surely solve your problem
Ayan

Report message to a moderator