Last updated on NOVEMBER 02, 2015
Applies to:Siebel Media - Version 22.214.171.124.7 [IP2014] and later
Information in this document applies to any platform.
ACTUAL OR UNEXPECTED BEHAVIOR
When querying a date time field with format as 'm/dd/yyyy Hr:min AM/PM', 00
is getting placed in the seconds place holder like 'm/dd/yyyy hr:min:00'
thus fetching wrong results.
'00' should not be placed in the seconds field while querying on date fields.
1. Change the data type of the planned start field in Activity list applet to
2. Check for a value in planned start in the DB where the seconds column has
a non zero value.
3. In the activity list applet, query a record using the same value as you
picked in step 2. Make sure you provide the search value in the format
'm/dd/yyyy Hr:min AM/PM'.
4. Hit enter. Note that no results is returned.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms