Home / Questions / 538399
Accepted
Emmanuel Gonzalez
Asked: 2022-08-04 09:52:12 +0800 CST 2022-08-04 09:52:12 +0800 CST

How to translate a date into Spanish?

  • 772

I have the following code in codeigniter 4:

$recordset=$this->db->select('turno_id, paciente,date_format(fecha, "%W %d-%M-%Y %H:%i") as fecha,observaciones,obra_social,usuario_id' , false)
                                        ->where('year(fecha)','year(now())', false)
                                        ->where('usuario_id',$usuario_id)
                                        ->get("turnos");

That returns the date to me in this way: Wednesday 22-June-2022 23:16and through Datatables I dump it into a table. How do I get it to return to me in Spanish or translate it into Spanish?

codeigniter

2 Answers

  1. Have you tried using setlocale? I used it in a pure PHP code without DB. It received the date from a field and initially it printed the same way it prints you. But with setlocalea slightly different syntax, I managed to get it to print in Spanish.

    I leave the code to see if it can help you or give you an idea:

    <?php
//recibir los datos del formulario
setlocale(LC_ALL, 'spanish');
$fecha = $_POST["fecha"];
$fechaNueva = date("Y-m-d", strtotime($fecha));
$fecha=strftime("%A %d de %B del %Y", strtotime($fecha));  //fecha tipo martes 17 de mayo del 2022 
echo "$fechaNueva => la Fecha ingresada fue: ".$fecha
    • 2
  2. Best Answer

    Already solved. Since I am using codeigniter3 I created a model with the following code:

    $this->db->query("SET lc_time_names = 'es_ES'");

    and then I loaded it in config->autoload like so

    $autoload['model'] = array('Traducciondefecha_model');

    The following article gave me an idea.

    • 0