[haymps]

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.yiiframew...i/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?

[Backslider]

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.

[bennouna]

Hello

I don't get it. You say create_time is a timestamp? Like a Unix one: '1343392756', or a date: '2012-07-29'?

[Backslider]

bennouna, on 29 July 2012 - 05:59 AM, said:

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]

Backslider, on 30 July 2012 - 12:08 AM, said:

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.