Home / Questions / 144577
Accepted
Sebastián Lagos Yañez
Asked: 2020-03-09 11:30:20 +0800 CST 2020-03-09 11:30:20 +0800 CST

How can I convert a date type string to date?

  • 772

what happens is that I have this a date type input, what I want to do is insert this date that comes to me like this from the sql server database "2018-03-31 00:00:00"and I want to be able to put it inside the input.

var date = "2018-03-31 00:00:00";
var fecha =new Date(date);

$("#fecha").val(fecha);
<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>

<input type="date" id= "fecha">

I have tried the example above but I don't know what it could be, or maybe there is another way.

javascript

2 Answers

  1. Best Answer

    Hello! I've tried your code, and it seems to me that the input type date receives a string for value, not a Date() object. At least I tried it like this, and it worked O_o:

     <input type="date" id="fecha" />
    
    <script>
    document.getElementById("fecha").value = "2018-03-08";
    </script>

    *Note that the time segment should not go, only the date. **I tried it with basic JS, but using JQuery it should be the same...

    • 2 
  2. function formatDate(date) {
  var meses = [
    "Enero", "Febrero", "Marzo",
    "Abril", "Mayo", "Junio", "Julio",
    "Agosto", "Septiembre", "Octubre",
    "Noviembre", "Diciembre"
  ];

  var dia = date.getDate();
  var mesIndex = date.getMonth();
  var ano = date.getFullYear();

  // Formato de la fecha, acá puedes generar el formato que quieras
  return dia + ' ' + meses[mesIndex] + ' ' + ano;
}

// Obtengo el valor obtenido de la DB
var fecha = "2018-03-31 00:00:00";

// Muestro el valor formateado en el elemento
$("#fecha").val(formatDate(fecha));
    • 0