I have done a search and could not find a discussion related to grabbing the time from SQL in a specific format that I am looking for, so I am seeking your wisdom here.
I am querying the Quality Management database to retrieve the localStartTime field name for a specific call and storing it in a variable named QMCallStartTime. In order to make this work, I had to set this variable be type java.sql.Timestamp.
I am then converting QMCallStartTime into a String so that I can manipulate it (I am parsing out the hour, minute, and second by substring). I am expecting the String to store the time in the following format, for example: 09:07:53 AM PDT. However, the time is being stored as 9:07 AM. In the Set object, I have the option to choose an encoding option for the QMCallStartTime variable. No matter if I set it to Medium Time or Long Time, it seems to be defaulting to Short Date (the top option) after I re-open the Set object.
Are you getting this error “Installer User Interface Mode Not Supported. The installer cannot run in this UI mode. To specify the interface mode, use the -i command-line option, followed by the UI mode identifier. The value UI mode identifiers...
The below trick might come handy when you have to add a new node to a cluster but you don't have or is unsure of the security password for the publisher. This procedure has been around for ages.
1) Login into the CLI of the Publisher.