sql - Laravel Eloquent 数据库迁移

Question

我们想计算数据库上两个不同日期字段之间的持续时间。谁能帮助将此 SQL 查询转换为 Laravel 中的数据库迁移？

CREATE TABLE api_incident_duration 
(START DATETIME, END DATETIME, elapsed DECIMAL(5, 2) 
AS (ROUND(TIMESTAMPDIFF(MINUTE, START, END) / 60, 2)));

也许：

$table->dateTime('startdatetimepicker')->nullable();
$table->dateTime('enddatetimepicker')->nullable();
$table->decimal('elapsed', 5, 2)
   ->virtualAs(ROUND(TIMESTAMPDIFF(MINUTE, startdatetimepicker, enddatetimepicker) / 60, 2));

标签： sqldatabaselaraveleloquentlaravel-migrations