No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
9 Posted Topics
Use To_char Function To_char(date,'dd-mm-yyyy') In Which Format You Use Also To_date Function To_date(date,'dd-mm-yyyy') Also To_char(to_date(date,'dd-mm-yyyy'),'dd-mm-yyyy'))
You Have to use Date Fromat To_Date ('20-may-2003','dd-mon-yyyy') and to_date('01-oct-2002','dd-mon-yyyy') and you find between this greatest.
Use To_Char function to get date in Desired Format.
[code=sql]SELECT NetAmout FROM MONTHLYBILLS WHERE REGNO = '047080809' AND TRUNC(BILLDATE) BETWEEN '01-AUG-2008' AND '30-AUG-2008' [/code] In above Query written 4 rows in which 3 rows showing netamount 0 and last 4 row showing netamout 4200. [code=sql]SELECT DECODE( SIGN(SUM(NETAMOUNT)),0,0) FROM ALMONTHLYBILLS WHERE NETAMOUNT NOT IN (SELECT DECODE( SIGN(SUM(NETAMOUNT)),1,0) FROM MONTHLYBILLS ))[/code] …
I am trying Ms flex Grid attached with combo box. Can anyone give me source or soloution.
[QUOTE=kehar;446253]Hi I have used three combo box in VB 6 form one for selecting date one for month and one for year. If the selection is say 12/07/2007 then I need it to be converted as 12/07/2007 under one field i.e date field of access database. So how can I …
I want to begin to create dll in visual basic 6.0. Can anybody give brief idea or examples.
I am using oracle query in that four fields are number. I am subtracting that field such as (field1 - field2 -field3 - field4) as DNF Actually I am creating query in view. While creating this view the last field DNF is created as varchar2(40) automatically. I am using this …
i have the following query SELECT C.FIELD6 ,C.FIELD2,C.TRANSACTIONNO FROM ipfroutine_deduction a,Servicemaster B,INPATIENTBILLALLDETAILS C, Departments D,INPATIENTBILLS E WHERE a.ipftestcd=b.code AND C.BILLNO=E.BILLNO and trim(a.ipftestname)=trim(b.childname) AND TRIM(B.childname)=TRIM(C.FIELD2) AND TRIM(A.IPFDEPTCD)=TRIM(C.DEPTCD) AND TRIM(C.DEPTDESCR)=TRIM(D.NAME) AND E.FROMDATE BETWEEN TRUNC(A.IPFFROMDATE) AND NVL(TRUNC(A.IPFTODATE),E.FROMDATE) AND C.BILLNO = 'D00024585' It's result as NO FIELD6 FIELD2 TRANSACTINO 1 220 CHG (HB TC …
The End.