You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Show current system Date and time if value is null

in Reporting & Analytics for B2C Service 1 comment

Hi,

I’m working on an Oracle Service Cloud (OSvC) report and need to create an SQL expression which should show SystemDate or better Current Date and time

I tried the following expressions, but they all give syntax errors:

IF(user_trans.end_dttm IS NULL, sysdate, user_trans.end_dttm)

IF(user_trans.end_dttm IS NULL THEN sysdate ELSE user_trans.end_dttm)


Also, what is the proper function or variable for current date/time in OSvC? Is it sysdate, CURRENT_DATE, NOW(), or something else?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!