Date and Time with AM/PM Format in mysql

Date and Time with AM/PM Format in mysql:
use listed below sql:



SELECT DATE_FORMAT(my_entry_date_time, '%d/%M/%Y %r') FROM my_table