[beimar24]

Very good day dear Engineers

I have the following question

I have a date field in datetime format

where I store the date and time of the entry of personnel

Now I need to separate the date and time display time only

 

in advance thank you very much for your help

Greetings from bogota Colombia

 

 

Separar  la hora de la fecha  en campo datetime

 

Muy buen dia queridos Ingenieros

Tengo la siguiente pregunta

tengo un campo fecha con formato datetime

donde almaceno la fecha y la hora de la entrada del personal

ahora necesito separar la hora de la fecha  y  solo mostrar  la hora 

 

de antemano muchas gracias por su colaboracion 

Saludos desde bogota Colombia

 

 

[Amit Shah]

It is very simple. You can define the columns of your display that you need (making sure you add the date & time columns too) and on both of them, you can make a column_callback where for the date field, you just return the date extracted from datetime field of yours and other column, just time..

[beimar24]

thank you very much for responding, but I really do not understand you

I have the following,

  database in a field called date

datetime format

and I stored this 17/06/2013 12:08:04

 

and need is only showing 12:08:04

time

 

in advance thank you very much for your help

[davidoster]

As [member=amit shah] suggested just do (on your controller),

 

$crud->callback_column('date', array($this, '_cb_date'));

 

and then 

 

public function _cb_date($value, $row)

{

 $my_time = date("H:i:s",strtotime($value));

 return '<div class="text-left">' . $my_time . '</div>';

}

[beimar24]

Dios los Bendiga muchas gracias por su colaboración

me funciona perfecto 

 

Cordial saludo 

[Priss Guerrero]

Thank you, Davidoster!!!

 

I was with the same problem, but I need the d-m-Y. I just changed and it worked very well! 

 

Big big Thank you!