My Oracle Support Banner

Today() Function Is Not Fetching Correct Records In Query Mode (Doc ID 2687020.1)

Last updated on AUGUST 30, 2020

Applies to:

Siebel Call Center - Version 20.5 to 20.6 [Release V17]
Information in this document applies to any platform.

Symptoms

Today() function is fetching in correct records for all Date fields after apply siebel 20.5

The function Today() can be used to fetch all the records created today, however the function fetches other records as well

The issue can be reproduced at will with the following steps:

1. Go to Response View
2. In "Response Detail Entry Prospect Applet" click on Query button
3. Enter Today() as criteria In "Created Date" Field
4. Click on "Go" button
5. Expected to fetch all the records of today's date, however the system fetches all records irrespective of date

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.