Date format

[Xtremer360]

I'm trying to turn 2012-09-12 14:00:00 into September 12, 2012 2:00 pm using the php date function but I'm getting a  A non well formed numeric value encountered error and not sure if I just didn't apply the function correctly or am missing something. Any ideas?

 

date('F d, Y h:i:s a', $row->news_article_posting_date)

[lemmin]

date() accepts an integer in the form of a timestamp as the second parameter. You are probably passing it a string: "2012-09-12 14:00:00." Try using strtotime():

 

date('F d, Y h:i:s a', strtotime($row->news_article_posting_date))

 

http://us2.php.net/manual/en/function.date.php

http://us2.php.net/manual/en/function.strtotime.php

[Pikachu2000]

It would make more sense to do this in the query itself with MySQL's DATE_FORMAT() function.

[Xtremer360]

It would make more sense to do this in the query itself with MySQL's DATE_FORMAT() function.

 

What's the advantage?

 

[Pikachu2000]

Speed and efficiency. The php date/time functions are very slow relative to the MySQL functions.

[Xtremer360]

Well I'm working it into my query but I'm getitng a

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in /home/xtremer/public_html/kowmanager/app/models/news_model.php on line 31

 

 

$this->db->select("DATE_FORMAT(".$this->master_model->news_articles_table.".news_article_posting_date, '%M %D, %Y') AS news_article_posting_date", FALSE);
$this->db->select("CONCAT_WS(' ', ".$this->master_model->users_table.".first_name, ".$this->master_model->users_table.".last_name) AS author", FALSE);

[lemmin]

I don't see a syntax error there. Can you post more code from around it and note which is line 31?

[Xtremer360]

I've triggered it to be those two lines.

[Jessica]

Post lines 30-32.

[booxvid]

It would make more sense to do this in the query itself with MySQL's DATE_FORMAT() function.

 

Agree ^

[PFMaBiSmAd]

I'm going to assume that you solved the php syntax error in this thread, because you started another thread for a sql syntax error you made trying to 'fix' the php error.