Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

_Zaman's avatar

Date picker error

Hi, I am using bootstrap date time picker and when I try to insert selected time it showing me an error "SQLSTATE[22007]: Invalid date time format: 1292 Incorrect date time value: '21 December 2012 - 03:25 PM' for column 'startDate' at row 1 " then I used in my controller $iVisitors->startDate = date("Y-d-m H:i:s", strtotime(request('startDate')));

but now it stores a default time 1970-01-01 00:00:00 not my selected time. How can I store my selected date time?

0 likes
3 replies
crnkovic's avatar

Is startDate attribute being cast to Carbon? In what format is startDate from the request?

$iVisitors->startDate = Carbon::parse($request->input('startDate'));

_Zaman's avatar

@crnkovic. But showing another exception "DateTime::__construct(): Failed to parse time string (12 August 2018 - 02:20 PM) at position 15 (-): Unexpected character"

Please or to participate in this conversation.