Originally Posted by flyboy

They use format masks which are also described in the SQL Reference book.

'PM' is not valid format mask - AM/PM specification is represented by 'AM' mask.

Ready, fire, aim (or trial and error) method is not the best way to develop.
Maybe you shall study the documentation first.