[color=#333333][size=4][b]
DATE_DIFF Function In informatica (TO_DATE conversion error)[/b][/size][/color]

[color=black][font=arial]
DATE_DIFF(P,Q, 'HH24' ) and DATE_DIFF(P,Q, 'MI' ) is not working

I have two input fields A and B where the data type is String and the values are
A- 07:30
B- 20:00 (24 hr format)
- I need to calculate the time difference between the two fields A and B which means - the result should be 14.30 hrs.

I converted the two string fields to TO_Date as

P-->TO_DATE(A, 'HH24:MI') and Q-->TO_DATE(B, HH24:MI')

Now, DATE_DIFF(P,Q,'HH24')||DATE_DIFF(P,Q,'MI') -- Data type as Double.

Still I get the error as Invalid string conversion to date[/font][/color]

andhukey Non it bets antaa lolli undadhu