角度 - 日期时间格式无效:1292 日期值不正确

Question

我正在开发一个客户端应用程序。Laravel-5.8是后端，Angular-7是前端。我正在使用发布请求。

client-quote-landing.component.ts

import { Component, OnInit, Inject, LOCALE_ID, TemplateRef } from '@angular/core';
import { Router, ActivatedRoute } from '@angular/router';
import { ClientQuoteService } from '../../../../shared/services/client-quote.service';
import { first } from 'rxjs/operators';
import { ToastrService } from 'ngx-toastr';
import { formatDate } from '@angular/common';
import { Validators, FormBuilder, FormGroup, FormControl } from '@angular/forms';
@Component({
selector: 'app-client-quote-landing',
templateUrl: './client-quote-landing.component.html',
styleUrls: ['./client-quote-landing.component.scss']
})
export class ClientQuoteLandingComponent implements OnInit {
quoteModel: any = {};
formattedAddress = '';
truck_types = [];
constructor(
private clientQuoteService: ClientQuoteService, private toastr: ToastrService,
private router: Router,
@Inject(LOCALE_ID) private locale: string,
private route: ActivatedRoute
) {
}
ngOnInit() {
window.dispatchEvent(new Event('load'));
window.dispatchEvent(new Event('resize'));
}

client-quote-landing.component.html

<form name="quote" #quoteform="ngForm" (ngSubmit)="onCreateQuote(quoteform);" method="post" novalidate>
<div class="row">
<div class="col-xs-12">
<div class="col-xs-6">
<label for="loading_date">Loading Date<span style="color:red;"> *</span></label>
<div class="input-group date">
<mat-form-field>
<input matInput [matDatepicker] = "picker" placeholder = "Choose a date" name="loading_date" [(ngModel)]="quoteModel.loading_date" #loading_date="ngModel" [ngClass]="{'is-invalid' : loading_date.invalid && ((loading_date.dirty || loading_date.touched) || quoteform.submitted)}"   required>
<mat-datepicker-toggle matSuffix [for] = "picker"></mat-datepicker-toggle>
</mat-form-field>
<div class="form-feedback" *ngIf="loading_date.invalid && ((loading_date.dirty || loading_date.touched) || quoteform.submitted)">
<div style="color:red;" *ngIf="loading_date.errors?.required"class="alert alert-danger">Loading Date is required.</div>
</div>
</div>
</div>
</div>
</div>
<button style="margin:5px"  type="submit" class="btn btn-success" > Get A Quote</button>
</form>

当我单击提交按钮时，没有任何反应，然后我检查了网络，我收到此错误：

消息："SQLSTATE[22007]：无效的日期时间格式：1292 列clientportal的日期值不正确：'2019-09-26T23：00：00.000Z' 。client_quotes.loading_date在第 1 行(SQL：插入client_quotes(first_name，last_name，email，phone，business_name，address，comment，truck_type，truck_required，quote_origin，quote_destination，commodity，loading_date，updated_at，created_at( 值 (迈克尔， 伊多乌， [e-mail]， 33334444444444， 乔拉米克， ddsds， dd， 住宅， 2， ddds， ssa， ee， 2019-09-26T23：00：00.000Z， 2019-09-19 00：53：55， 2019-09-19 00：53：55((">

在MySQL数据库中，loading_date数据类型是日期。

如何解决此错误？

Answer 1

将loading_date数据类型更改为varchar(20(，错误是因为您选择了错误的数据类型。