Parsing datetime from MySQL

Parsing datetime from MySQL

04-12-2010, 12:46 AM

[eluser]xeroblast[/eluser]
you could use:

date only:

Code:
echo date("m/d/Y",strtotime($from_mysql_datetime));

time only:

Code:
echo date("H:i:s",strtotime($from_mysql_datetime));

both:

Code:
echo date("m/d/Y H:i:s",strtotime($from_mysql_datetime));

make sure your datatype in mysql is datetime or timestamps.

Messages In This Thread

Parsing datetime from MySQL - by El Forum - 04-11-2010, 06:15 PM

Parsing datetime from MySQL - by El Forum - 04-12-2010, 12:46 AM

Parsing datetime from MySQL - by El Forum - 04-12-2010, 12:55 AM

Parsing datetime from MySQL - by El Forum - 04-12-2010, 01:02 AM

Parsing datetime from MySQL - by El Forum - 04-12-2010, 07:23 AM

Parsing datetime from MySQL - by El Forum - 04-12-2010, 07:30 AM

Parsing datetime from MySQL - by El Forum - 04-12-2010, 07:34 AM

Parsing datetime from MySQL - by El Forum - 04-12-2010, 10:01 AM

Parsing datetime from MySQL - by El Forum - 04-12-2010, 10:19 AM

Parsing datetime from MySQL - by El Forum - 04-12-2010, 04:59 PM

Parsing datetime from MySQL - by El Forum - 04-12-2010, 05:12 PM

Parsing datetime from MySQL - by El Forum - 04-13-2010, 12:14 AM