Home » Developer & Programmer » Forms » Help Need In Query
Help Need In Query [message #78908] Thu, 28 March 2002 19:15 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re: Help Need In alert [message #78953 is a reply to message #78908] Fri, 05 April 2002 20:02 Go to previous message
rama krishna
Messages: 97
Registered: December 2001
Member
see set_alert_property built-in help
for this u'll get the solution for this.

cheers
ram
Previous Topic: need help in calculation
Next Topic: Dynamic specification of Table and Field
Goto Forum:
  


Current Time: Sun Mar 29 11:23:04 CDT 2020