'To_Char()' Function Does Not Work As Expected When Used With 'TimeStamp()' Function
Last updated on MARCH 02, 2017
Applies to:Siebel Tools - Version 126.96.36.199 SIA  and later
Information in this document applies to any platform.
Checked for relevance 03-Feb-2015
The customer had a business requirement to capture and format a date/time value, so they performed the following configuration using a Calculated Field with the 'TimeStamp()' function and the 'To_Char()' function to fulfill the business requirement.
a. Created a new Calculated Field
b. Used 'TimeStamp()' function to capture the current date and time
c. Used 'ToChar' function to construct the string in format DDMMYYYY_HHMMSS (DD Day, MM Month, YYYYY Year, HH Hour, MM Minutes and SS Seconds).
The Day, Month, Year and Hours were successfully captured and displayed but the Minutes and Seconds were incorrect. The Minutes were always displayed as '09' and the Seconds were always displayed as 'SS'
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