How do I get "mm-dd-yyyy hh:mm:ss AM/PM" format date from mysql database with php?

Question

How do I get "mm-dd-yyyy hh:mm:ss AM/PM" format date from mysql database with php?

Answer 1

Try:

$query="SELECT CONVERT(VARCHAR,DateColumn,100) AS DateColumn FROM Table tablename";

$result=mysql_query($query);

Answer 2

http://www.tizag.com

Answer 3

Get your date from MySQL with a mysql_fetch_assoc function for example, then simply use the DATE php function to format the date as you see fit.



But, here's the trick: you have to use the STRTOTIME function FIRST! Aha! This will convert the "text time" from mysql into a Unix timestamp, a value that the DATE function will understand.



$mydate = ... // Get this date from mysql



echo date("m-d-Y H:i:s A", strtotime($mydate));



That's it! Good luck!