Converting SQL expression to Oracle

Cognos 10 Business Intelligence Report Studio
1

Hello Guru,

I need to help with converting this expression from SQL to Oracle: if (month(current_date) < 10) then (year(current_date)) else (year(current_date) + 1). below is the error message that I’m getting.

Error Message:

UDA-SQL-0107 A general exception has occurred during the operation “prepare”.
ORA-00904: “YEAR”: invalid identifier.

I appreciate your help in advance

Thanks, aka2d7 :slight_smile:

2

your: year(currentdate)

…will need to be something more like:

to_integer(to_char(sysdate(),‘yyyy’)).

i do not have an Oracle database to test this.

3

Thanks for your help! I’ll test this out to make sure it works…

:slight_smile: