0

I try to use the correct format for the date that I have in OracleBD and then show in a form with.

<input type="date"

but that doesn't work.

Code I'm using:

$stid = oci_parse($conexion, "SELECT COD_ALUMNO,NOMBRES, APELLIDOS,SEXO,TO_CHAR(NACIMIENTO, 'DD-MON-YYYY'),DIRECCION,TEL_TUTOR,COD_GRUPO FROM ALUMNOS WHERE COD_ALUMNO = :cod_alu");

Form: enter image description here

DB part: enter image description here

Record:

YakovL
  • 7,557
  • 12
  • 62
  • 102
Abner Kayits
  • 3
  • 2
  • According to [this](https://stackoverflow.com/questions/7372038) you should use `YYYY-MM-DD` format and let the browser do the rest. – Sal Aug 16 '17 at 12:41

1 Answers1

0

I think you should as the name for column like this:

$stid = oci_parse($conexion, "SELECT COD_ALUMNO,NOMBRES, APELLIDOS,SEXO,TO_CHAR(NACIMIENTO, 'DD-MON-YYYY') AS NACIMIENTO,DIRECCION,TEL_TUTOR,COD_GRUPO FROM ALUMNOS WHERE COD_ALUMNO = :cod_alu");
Hong Van Vit
  • 2,884
  • 3
  • 18
  • 43