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


#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: