[SQL & PHP] Help using SQL cadastring date format

Resolved

Hello everyone, hope y'all having a good one!!

So, I'm having trouble with the date format.

Using: xampp, which means that I'm running mysql and phpmyadmin

This is the page I use to insert the data, which I coded myself, http://prntscr.com/g9ryj7

This is the code for the date field:

<td><input class="form-control" type="date" name="data" /></td>

As you can see here, this http://prntscr.com/g9rxmp is my database in phpmyadmin, which is cadastring data only with 0000-00-00

I've tried inserting data in the date field like 10/10/1000 and 1000-00-00 and also 52-62-5003, but I can't actually put the date I want in the database.

So, how do I use the date type?? Do I have to type anything, should it just get the date of the computer?? Or, should I just change from date to varchar in the database??

Thanks everyone, see you soon! ;)

Posted Aug 17, 2017, 7:58 PM UTC

22
Loading comments…