[Sonelal Singh]

Hi,

 

I have a field(create_date) in USER table.This stores default datetime(2015-07-01 03:05:34) value in the table as its value.

When I am displaying this value in front end it display as "01/07/2015 - 00:00". But I want to display date as "2015-07-01", To achieve this I used this code $crud->field_type('created_date', 'date') for formatting.So now it display as "01/07/2015".

 

So my question is how can I display this date as "2015-07-01".

 

 

 

[Paul Savostin]

Hi!

Frontend - you mean on the site part or admin site part?

On the site you can change output do smth date('Y-m-d', strtotime($your_date));

On the admin site in table like column you can add

->callback_columns('your_date', array($this, 'callback_date'));

function callback_date($val, $row)
{
        return date('Y-m-d', strtotime($val);
}

in read state do the same like above only diff it will be for callback_read_fields


in insert or update state nothing to do cause you have the datetime picker.

Hope it helps

[Sonelal Singh]

Hi Paul,

 

Thanks for your reply.

 

In database my field name is "create_date" and date type is "timestamp" and default value is "CURRENT_TIMESTAMP".

 

But when I fetch and displaying this field in front end it display like "30/11/1999" (d/m/y) format.

 

I want to display this field like "1999-11-30".

 

 

 

I have applied you suggestion in my code like below -

 

$crud->callback_columns('created_date', array($this, 'callback_date'));

 

and in same controller I have created callback function like below 

 

public function callback_date($val, $row)

{

        return date('Y-m-d', strtotime($val));

}

 

But I am getting below error

Call to undefined method Grocery_CRUD::callback_columns() 

[Paul Savostin]

Hi! If in database you have timestamp then you dont need to use function "strtotime" - it will be just date('Y-m-d', $your_timestamp_date);

I have misprint in word callback_column - it will be without "S" at the end (You can see list function on the GC site)



Man, learn PHP and GC, I see that you just copy paste and dont thinking at all...

[Sonelal Singh]

Hey Paul,

 

Thanks for your help.

It worked   :) 

[Paul Savostin]

you're welcome!

[Margarita Mota]

Thanks, that work for the list, but if I go inside the record ( view read) the date keep the unix format, somebody can help me? I want to see the date in normal format when I go into the view of a simple record