reason for cast(NULL as DOUBLE PRECISION )
Hi All,
One of my report has the below query.It doesn't show any data.Can someone please tell me when do we get cast(NULL as DOUBLE PRECISION ) in our query.
case when case when cast(ROUND( ( CAST(ws.TO_DATE as DATE) -
CAST(TO_DATE('2011-01-19 17:06:56' , 'YYYY-MM-DD HH24:MI:SS') as DATE) ) * 86400 ) / nullif( 3600, 0) as FLOAT ) > 0
then (cast(NULL as DOUBLE PRECISION ) - cast(NULL as DOUBLE PRECISION )) / nullif( cast(ROUND( ( CAST(ws.TO_DATE as DATE) - CAST(TO_DATE('2011-01-19 17:06:56' , 'YYYY-MM-DD HH24:MI:SS') as DATE) ) * 86400 ) / nullif( 3600, 0) as FLOAT ), 0)
else NULL
end > 0
then case when cast(ROUND( ( CAST(ws.TO_DATE as DATE) - CAST(TO_DATE('2011-01-19 17:06:56' , 'YYYY-MM-DD HH24:MI:SS') as DATE) ) * 86400 ) / nullif( 3600, 0) as FLOAT ) > 0
then (cast(NULL as DOUBLE PRECISION ) - cast(NULL as DOUBLE PRECISION )) / nullif( cast(ROUND( ( CAST(ws.TO_DATE as DATE) - CAST(TO_DATE('2011-01-19 17:06:56' , 'YYYY-MM-DD HH24:MI:SS') as DATE) ) * 86400 ) / nullif( 3600, 0) as FLOAT ), 0)
else NULL
end
else NULL
end
> T621750.STANDARD_RATE_1
then 1
else case when cast(NULL as DOUBLE PRECISION ) / nullif( cast(NULL as DOUBLE PRECISION ), 0) * 100 > 5
then 2 else NULL end end is not null
Thnaks in Advance