-1

I have an input in my page to capture a date. I need it in "yyyy-mm-dd" format but it's saving it in "yyyy-mm-ddthh-mm-ssz".

<input id="celular" type="date" date="yyyy/mm/dd" class="browser-default" ng-model="cumpleanos" >

I need to format to yyyy-mm-dd in the front or in the back.

When I inspect the header of the data send I see this:

cumpleanos: "2018-03-01T05:00:00.000Z"

and the database sends me this error:

Incorrect date value: '2018-03-01T05:00:00.000Z' for column 'cumpleanos' at row 1

The column cumpleanos is a date type column.

Anthony
  • 36,459
  • 25
  • 97
  • 163
Alberto José
  • 65
  • 1
  • 7
  • You've almost tagged every language, how about you let us know which language you'd prefer the formatting in, also, this is very trivial, surely you found *something*? – Adam Mar 02 '18 at 20:54
  • 1
    Just take `substr($in,0,10)`? Better still, use `DateTime::createFromFormat()` to ensure it is a valid input, then `format` as needed. – Niet the Dark Absol Mar 02 '18 at 20:54

1 Answers1

-2

You could just use substring:

var time = "2018-03-01T05:00:00.000Z";
time = time.substring(0,10);

console.log(time);
// "2018-03-01"
Levi Rocha
  • 88
  • 3