Level 63
Have you checked if the milliseconds are stored in the database with the right values ?
Have you checked the date and time returned by the form (dd($start_time)) ?
1 like
Sep 7, 2023
10
Level 1
Editing milliseconds not updating database
Hello, I have a textinput, type datetime-local and with a step of .001 in which I store the date-time with milliseconds. When creating a new record I have no problems, but if, for example, I go to edit and modify only the milliseconds, it is not updated in the database. But for example if I update the seconds along with the milliseconds, then the milliseconds are updated.
Model:
protected $casts
= [
'start_time' => 'datetime:Y-m-d H:i:s.v',
];
I have activated the mysql log and the new time does not arrive with the changed milliseconds.
I'm using filamentphp form.
Level 1
@vincent15000 Yes, the value returned by the form and the one stored in the database is correct. It only does not update when I change only milliseconds, if I change any other value along with the milliseconds it is fine.
1 like
Level 70
@mendizalea Just wondering, is there any particular reason to update milliseconds?
2 likes
Level 1
@tisuchi Yes, it is for timing sports events and there may be cases in which the value needs to be changed.
1 like
Level 63
Please show your update code.
Level 104
Is seems that the update is not considered a change and therefore start_time is not dirty.
Try setting the $dateFormat property on the model so comparisons are made down to milliseconds:
protected $dateFormat = 'Y-m-d H:i:s.v';
2 likes
Level 63
@tykus What does protected $dateFormat ? Does it act as a kind of casting ?
Level 104
The storage format of the model's date columns
It is also used for comparison whenever Eloquent determines if date attributes are dirty.
1 like
Level 63
@tykus Oh so it's only to say to Laravel which format is used in the database. Ok ok thank you.
Level 74
You can also consider using database triggers to update the timestamp.
https://tray2.se/posts/using-table-triggers-to-log-changes-in-your-database-tables
1 like
Please or to participate in this conversation.