You can run this query to change all the formats, you'll need to specify a time format as well. Something like this would work:

update ubbt_USER_PROFILE set USER_TIME_FORMAT='m/d/y | h:i A'