Data format issue in Mysql

@bhhussain try this

$('.date-picker').datepicker({
                format: 'yy/mm/dd',
                autoclose: true,
                todayHighlight: true
            });

Check this mostly using this with laravel,

https://carbon.nesbot.com/docs/

Well, before you insert it in the database you need to convert it so it's in the correct format. You can do the conversion yourself in either the frontend using momentjs or using Carbon in your PHP backend.

Using Carbon it will be handled automatically for you:

$date = Carbon::createFromFormat('dd/mm/yyyy', $date);

This code is not working for me.

Is any other way?

Thank you

Can you show your current code that does not work? Both solutions should work :)

Use as like below and check,

 $date  = Carbon\Carbon::createFromFormat('Y-m-d H:i:s', $date)->format('Y-m-d');

I added use Carbon\Carbon; in the top and below code

public function store(Request $request, Account $account, Item $item) {

    $id = Account::orderByDesc('th_tran_no')->first()->th_tran_no ?? date('Y') . 00000;
    $year = date('Y');
    $id_year = substr($id, 0, 4);
    $seq = $year <> $id_year ? 0 : +substr($id, -5);
    $new_id = sprintf("%0+4u%0+6u", $year, $seq+1);      


    if($request->th_attach->getClientOriginalName())
    {
        $ext = $request->th_attach->getClientOriginalExtension();
        $file = date('YmdHis').rand(1,99999).'.'.$ext;
        $request->th_attach->storeAs('public/categories',$file);
    }    
    else
    {
        $file='';
    }
    $account->th_attach = $file;
    $account->th_supp_name = $request->th_supp_name;
    $account->th_emp_name = $request->th_emp_name;
    $account->th_item_type = $request->th_item_type;
    
    $date  = Carbon\Carbon::createFromFormat('Y-m-d H:i:s', $th_bill_dt)->format('Y-m-d');
    
    $account->th_bill_dt = $date;     


    $account->th_bill_amt = $request->th_bill_amt;
    $account->th_bill_no = $request->th_bill_no;
    $account->th_pay_mode = $request->th_pay_mode;
    $account->th_purpose = $request->th_purpose;
    $account->th_item_type = $request->th_item_type;
    $account->th_tran_no = $new_id;
    $account->th_emp_name = Auth::user()->name;
    
    $account->save();       
    
    foreach ($request->td_item_desc as $key =>$name) 
    {
        $item = resolve(Item::class);     
        $item->td_item_desc = trim($name,'"');    
        $item->td_qty = $request->td_qty[$key] ;    
        $item->td_unit_price = $request->td_unit_price[$key] ;
        $item->td_tran_no = $new_id; 
        $item->save();
    }         
    return redirect('admin/accounts')->with('success','Transaction created successfully!');
}

I am getting this error message.

Class 'Carbon\Carbon\Carbon' not found

When I add the name space (namespace Carbon;) in this controller page then different error message is coming.

As you are already importing Carbon it should just be

 $date  = Carbon::createFromFormat('Y-m-d H:i:s', $th_bill_dt);

dump the request as it hits your server. Check the format of the date string.

Use Carbon::createFromFormat() to create a Carbon object using the format of the passed date

Pass the Carbon date time object to Eloquent. It will know how to use that Carbon object to update your database.

Sorry to bother all of you for small issue..

Still I have the problem..and error says

InvalidArgumentException Data missing

when I use the below code

$bill_dt = $request->th_bill_dt; $newdate = Carbon::createFromFormat('Y-m-d H:i:s', $bill_dt); $account->th_bill_dt = $newdate;

and this error message

ErrorException Undefined variable: th_bill_dt

when I use

$newdate = Carbon::createFromFormat('Y-m-d H:i:s', $th_bill_dt); $account->th_bill_dt = $newdate;

Really I am new and learning larvel.. that is the reason I am struggling in basic.. I do apologize

You dont have a variable called $th_bill_dt

Which variable should hold the date variable? Replace $the_correct_variable_name

 $date  = Carbon::createFromFormat('Y-m-d H:i:s', $the_correct_variable_name);

your missing data is because you are trying to parse a full date time string when you only have date (thanks for the mis-advice again @munazzil )

dd(request->all())

at the top of the method and check what date format is being sent

@sinnbeck This code is also not working.

I am trying like this

$date = Carbon::createFromFormat('Y-m-d', $request->th_bill_dt); $account->th_bill_dt = $date;

Error Message:

InvalidArgumentException Trailing data

sorry

$date  = Carbon::createFromFormat('Y-m-d', $request->th_bill_dt);        
$account->th_bill_dt = $date;   

HAVE YOU CHECKED WHAT DATE FORMAT COMES FROM YOUR FORM ?

otherwise you are just stumbling around

@bhhussain can you show here the result of this:

dd($request->th_bill_dt);

Before you try to create a carbon instance from it?

@bhhussain Actually I saw it now in your datepicker :)

so you should use this instead:

$date  = Carbon::createFromFormat('d-m-Y', $request->th_bill_dt);        

not vice-versa :)

Thank you .. It is working fine..