Unable to include seconds in date format for display
We would like to include seconds when viewing date fields in reports, the option "%S" does not work (displays "%S" instead of the seconds value).
Reproduce: on Localization > Date format, change the value of "Date Format: Complete Date and Time" from the default "%B %E%f, %Y %l:%M %P" to "%B %E%f, %Y %l:%M:%S %P" and load a report displaying a date column, you'll see something like "January 4th, 2021 3:28:%S PM".
First reported on stack exchange: https://civicrm.stackexchange.com/questions/38869/date-and-hour-format-with-seconds