Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
TIMESTAMP column issue in values set — Cloud Customer Connect
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

TIMESTAMP column issue in values set

Received Response
2
Views
5
Comments

Summary:

unable to apply date condition on the table which column data type is timestamp

Content (required):

We have table named "PER_CALENDAR_EVENTS" in which two dates column which data type is timestamp. Now when we pass it through values set based on the below parameter but system doesn't get this.

CAST(START_DATE_TIME AS date) <= TO_DATE(:{PARAMETER.P_TO_DATE},'YYYY/MM/DD')

AND CAST(END_DATE_TIME AS date) >= TO_DATE(:{PARAMETER.P_FROM_DATE},'YYYY/MM/DD')

Please advise.


Version (include the version you are using, if applicable):

22B

Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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