Siebel Business Process & Functionality (MOSC)

MOSC Banner

Calculation with timestamp() in siebel query language

edited Feb 19, 2016 8:07AM in Siebel Business Process & Functionality (MOSC) 3 commentsAnswered ✓

Hi fellow experts,

So I need to run this query:

field "Created" is in the last 2 hours

I need this query in 2 different places:

  1. A Search Specification expression for a Workflow Process Batch Manager server job
  2. a query expression for end user in the Siebel GUI

I'm actually struggling with the syntax.

in the GUI, I can't get the minus 2 hours working.

I'm stuck here and it doesn't work:

(GUI) Created >= (TimeStamp() - ((1/24) * (2)))

siebel throw an error about grammar rule / unexpected token.   

Any thoughts?

Cheers,

Matthieu

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center