Welcome to the new CogKnowHow.com!


If you have trouble logging in, reset your password via the login window
by clicking the 'Forgot Password' link.

Converting SQL expression to Oracle

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:

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.

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

:slight_smile: