Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Evaluate function for Date

user13816768Aug 27 2015 — edited Aug 27 2015

Hi All,

We have included a condition in the where clause of a logical table for a date field.

Evaluate('to_date(%1,%2)',"abcd".""."123"."Dim_SALES"."CREATED_DATE" ,'DD-MON-YY') > '01-JAN-15'

Now we have changed the data type of this field to timestamp and the above function is not working.

Can you please help me in getting this formula work for a timestamp.

Thanks

This post has been answered by user13816768 on Aug 27 2015
Jump to Answer

Comments

3993082

Did you manage to solve the issue?

3993082

Are these two issue related?

hi,

above one not exact in sync just fyr, or else raise a MOS ticket for better tracking and re-solution

     So something really is not in sync. Possible reason OPMN and EM communication syncronisation ?? Don’t know …. So thumb rule, as per this release, don’t rely on EM message on server issue and log …rather see if OPMN managed processes are up and running fine or not .

3993082

Hi,

Thanks a lot for your quick response. I will raise MOS ticket, since my issue looks to be pretty different.

Im not even using OPMN at all.

Thanks for your help

hi thanks kindly mark the thread as answered so that other potential users will check.

User_BUQDA

Is this issue resolved ? I am having same issue .

brahmayya kandra

Hi All,
Is it resolved. I have facing same issue for sbconsole.

brahmayya kandra

Hi All,
@User_SL3ZU

It's resolved after admin restart.

Thanks!

1 - 9
Locked Post
New comments cannot be posted to this locked post.

Post Details