BI Report to extract daily rates for a specific date range

Summary:

BI Report to extract daily rates for a specific date range

Content (please ensure you mask any confidential information):

Hi All,

I have a requirement to extract daily rates for rate type between different start date and end date. I have the below query developed however it is not returning any data as i put filter on conversion date column.

SELECT
GDR.from_currency,
GDR.to_currency,
To_char(GDR.conversion_date, 'YYYY/MM/DD', 'NLS_DATE_LANGUAGE=AMERICAN')AS CONVERSION_DATE,
GDCT.user_conversion_type,
GDR.conversion_rate,
1 / GDR.conversion_rate inverse_rate

FROM gl_daily_rates GDR,