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
|
|
|
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
|
|
|
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
|
|
|
Re: Help Need In alert [message #78939 is a reply to message #78908] |
Thu, 04 April 2002 01:15 |
anjana
Messages: 1 Registered: April 2002
|
Junior Member |
|
|
Hi all
I have an auto generated field named complained no and i want to use this generated field in my alert message . Pl help.
anjana
|
|
|
|