error

[srikanth d]

Imran sir,

actually i want to look is diffrence between two dates

for ex:- (22-02-2012)-(21-02-2012)=1day....and group by days

1.select txt_name_insurer,

to_date(DATE_CLAIM_DATE_SETTLEMENT,'dd-mon-yyyy')-to_date(DATE_CLAIM_DATE_INTIMATION,'dd-mm-yyyy') as dates

from table_name

where to_date(DATE_CLAIM_DATE_SETTLEMENT,'dd-mon-yyyy')-to_date(DATE_CLAIM_DATE_INTIMATION,'dd-mm-yyyy') is not null

note:- query 1 is executing

2..select txt_name_insurer,

(to_date(DATE_CLAIM_DATE_SETTLEMENT,'dd-mon-yyyy')-to_date(DATE_CLAIM_DATE_INTIMATION,'dd-mm-yyyy')) as d

from table_name

where to_date(DATE_CLAIM_DATE_SETTLEMENT,'dd-mon-yyyy')-to_date(DATE_CLAIM_DATE_INTIMATION,'dd-mm-yyyy') is not null

group by txt_name_insurer,(to_date(DATE_CLAIM_DATE_SETTLEMENT,'dd-mon-yyyy')-to_date(DATE_CLAIM_DATE_INTIMATION,'dd-mm-yyyy'))

note:- query 2 throwing error

can u plz help me out

[idba Javed]

Thanks for posting.

Here date format is different in the substration. At one place you are using "MON" and another place you are using "MM".

Change the format to MM everywhere.

Here are the queries.


SELECT txt_name_insurer,
  to_date(DATE_CLAIM_DATE_SETTLEMENT,'dd-mm-yyyy')-to_date(DATE_CLAIM_DATE_INTIMATION,'dd-mm-yyyy') AS dates
FROM table_name
WHERE to_date(DATE_CLAIM_DATE_SETTLEMENT,'dd-mm-yyyy')-to_date(DATE_CLAIM_DATE_INTIMATION,'dd-mm-yyyy') IS NOT NULL;



SELECT txt_name_insurer,
  (to_date(DATE_CLAIM_DATE_SETTLEMENT,'dd-mm-yyyy')-to_date(DATE_CLAIM_DATE_INTIMATION,'dd-mm-yyyy')) AS d
FROM table_name
WHERE to_date(DATE_CLAIM_DATE_SETTLEMENT,'dd-mm-yyyy')-to_date(DATE_CLAIM_DATE_INTIMATION,'dd-mm-yyyy') IS NOT NULL
GROUP BY txt_name_insurer,
  (to_date(DATE_CLAIM_DATE_SETTLEMENT,'dd-mm-yyyy')-to_date(DATE_CLAIM_DATE_INTIMATION,'dd-mm-yyyy'));

Cheers,
idba-Javed

[srikanth d]

Thanks for Reply Sir...

[idba Javed]

So is it working ? If yes , then click on "Mark as best answer".

Cheers.