does motion allow time / date stamp(with seconds) to be placed on footage

No, the only two timecode generators have to be set and animated manually.

There is a Time Date text generator that you can add.

More specifics on it here, but yes, it can show seconds:

https://help.apple.com/motion/mac/5.2/?lang=en#/motn1640679d

Again, the "Time Date" generator won't read from the "stamped" time/date recorded with the clips, you have to set it up manually. It is not a Time/Date reader, but a generator, generates from scratch, has to be set up and animated manually.

I don't see where OP explicitly asked if Motion could "read" the time/date information from a clip and stamp it. I only see if he asked if he can place a time/date stamp that includes seconds on footage to which, yes you absolutely can.