Virajsinh

dd-mm-yyyy hh:mm:ss am/pm MytSQL Date Formate

Jul 15th, 2020
534
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.09 KB | None | 0 0
  1. SELECT DATE_FORMAT('2020-07-09 19:32:04', '%d-%m-%Y %r');
  2. # Output : 09-07-2020 07:32:04 PM
Add Comment
Please, Sign In to add comment