to insert date/time values in SQL as you have spotted, any string format (a.m for example) will not be allowed to be inserted in SQL.
the formatting is automatically done either from the client or from the server in its representation layer, it automatically can detect what appropriate string to add at the end (a.m/p.m) since the time appears to be a 24 hour format.
|