haymps
(Peter Hayman)
July 28, 2012, 1:10pm
1
I am using the formatting ‘value’=>‘date(“M j, Y”, $data->create_time)’. I have a value in create_time, but when I use the expression, it is zero (i.e., expression returns Dec, 12 1969).
The formatting code for this is right out of http://www.yiiframework.com/doc/api/1.1/CGridView
For now, to remove the time stamp I used substr. But with this, I cannot format the date. Here’s my code (the commented out data expression is what is not working:
‘columns’=>array(
'id',
'title',
array('header' => 'date',
'value' => 'substr($data->create_time,0,10)'), //'date("M j, Y", $data->create_time)'),
Any ideas? Is this working for anyone else?
I had a problem with this also… didn’t have time to debug, so I just created a method and used it:
'value' => 'MyModel::model()->displayDate($data->create_time)',
*Edit - I just tested this and whatever problem I had has gone away.
abennouna
(Abennouna)
July 29, 2012, 10:59am
3
Hello
I don’t get it. You say create_time is a timestamp? Like a Unix one: ‘1343392756’, or a date: ‘2012-07-29’?
Its a timestamp. If its a regular date, you must use strtotime():
date("M j, Y", strtotime($data->create_time))
haymps
(Peter Hayman)
July 30, 2012, 3:28pm
5
Backslider:
Its a timestamp. If its a regular date, you must use strtotime():
date("M j, Y", strtotime($data->create_time))
That’s the ticket! Thank you! And yes, it is a timestamp from MySQL default value.