更新日期格式

I am unable to update mysql date

trying ,

mysql is remaining 0000-00-00 when inserting date format date('d-m-Y')

thank you

Use this instead:

date('Y-m-d')

Also, if you just want to use the current time/date and your MySQL server is in the same timezone as your web server, you can use NOW() in your SQL instead.