Yeah, MI is minute. SS(capital) actually does give you seconds. I usually to 'YYYY-MM-DD HH24:MI:SS' though would be easier to just set that as the default then you never need to format to_char by hand.