How to convert PHP time into read able form?

Question

Possible Duplicate:
Format mysql datetime with php

Well.. I have stored date(c) in Mysql DB and the data type i used in varchar. So it is stored in format 2012-07-01T22:03:02+05:30 . well it kinda look difficult to read.

can anyone help me how to convert it into something like July 1,2012 at 10:03 PM

for the day you could just use a substring and slice it to an array on `-`. — 11684, Jul 01 '12 at 16:59
It's not really a duplicate because Prakash seems to want to reformat a regular varchar string - but this problem would definitely be better solved by using a datetime or timestamp field. — Lack, Jul 01 '12 at 17:06

score 2 · Accepted Answer · answered Jul 01 '12 at 17:00

2

php.net/date php.net/strtotime

date( "F d, Y \a\t g:i a", strtotime( $databaseValue ) );

answered Jul 01 '12 at 17:00

phpmeh

1,752
2
22
41

Meh, I still voted to close with you. In the meantime, take the freebie. :P – phpmeh Jul 01 '12 at 17:03
Ok, I misspoke then. I flagged it. Freebie = answering an easy question. There's not many questions that I can answer on here. :P – phpmeh Jul 01 '12 at 17:05
date( "F d, Y \a\t g:i a", strtotime( $databaseValue ) ); it works but it is like July 01, 2012 a 10:00 pm i think /a is working but /t is not – Prakash Chhetri Jul 01 '12 at 17:27
Try just \at without the second slash – phpmeh Jul 01 '12 at 17:43

score 1 · Answer 2 · answered Jul 01 '12 at 17:14

You can still use MySQL date functions - mysql will implicitly cast them to date.

Say you have a table bla, and a field "mydate" of varchar, then just use the following SQL:

select date_format(mydate, '%M %e, %Y at %l:%i %p') as my_formatted_date from bla

score 0 · Answer 3 · answered Jul 01 '12 at 17:39

As of PHP 5.3:

$dateMySQL = '2012-07-01T22:03:02+05:30';
$inputFormat = 'Y-m-d\TH:i:sP';
$outputFormat = 'F j,Y \a\t h:i A';
$date = DateTime::createFromFormat($inputFormat, $dateMySQL);
echo $date->format($outputFormat);

which will print "July 1,2012 at 10:03 PM".

How to convert PHP time into read able form?

3 Answers3