I already asked Support for help with setting the value of a field to the current date/time with seconds using a workflow action; I'm doing this to reproduce the various core date fields in support cases but in seconds so we can run useful metrics. The solution given was not to use that field type at all.
Based on my testing, you can get the value of the time including the seconds by following the steps below:
A.
1. Go to Setup > Customization > CRM Fields > New
2. Enter a value for Label
3. Set the Type to Free-Form Text
4. Apply it to Case record
5. Set the Display Type to Disabled
B.
1. On your workflow state, click New Action and choose Set Field Value
2. Select the custom field you created on step A.
3. Set the Trigger On Before Record Submit
4. Click the Formula radio button and enter this: TO_CHAR(sysdate,'mm/dd/yyyy hh:mm:ss pm')
5. Click Save
I would have expected to create the custom date/time with seconds field then use a Set Field Value action that sets that field to the current date/time using either a formula or the Date section in the Value box. For the Date/Time with Seconds field type, the Date section in the Value box is not even selectable.I won't go further into the disappointing implementation of this field here.