I have a string representing a date. I want to store it in my database but the problem is that in my database the property is defined as date. How to correctly convert a string to a date so it can be stored in the database? This is how my string looks like: "fecha":"31 March 2023" . Thanks.
You can use the
strtotime()
function to convert any English text datetime description to a unix timestamp, and using thedate()
function you can format a unix timestamp. You can use both like this:$date = date('Y-m-d',strtotime($string));
You can write it into a mutator, or you can check out the date conversion article in the documentation:
Date Conversion Document