Level 1
not solved my problem
SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect date value: 'April 19, 2023' for column ibs.acquires.acquire_date at row 1
Apr 28, 2023
6
Level 1
how to change date format
SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect date value: '04-25-2023' for column ibs.acquires.acquire_date at row 1
my code $date = new \DateTime($request->ac); // use your CSV field here. $acq->acquire_date= $date->format('m-d-Y'); $tdate = new \DateTime($request->da; // use your CSV field here. $acq->expire_date= $tdate->format('m-d-Y');
i want my date format like(month,day,year) but it gaving me error mysql dateformat (year ,month,day) how to customized this and mysql datatype is date
Level 122
mysql needs to receive dates in Y-m-d format . don't try to change it.
Just display it differently when you need to present it to a user
Level 1
@Snapey ok
Level 51
You could use model casting - https://laravel.com/docs/10.x/eloquent-mutators#date-casting
So when you are saving the field you just send the Carbon/Date instance and let Laravel do its magic.
Please or to participate in this conversation.