Scheduled Publishing In Twill 3
Here’s what I’ve done so far:
1- Uncommented publish_start_date and publish_end_date in the migration.
Added them to the $fillable property in my model.
2- Cast these fields to datetime to avoid the DB error
My issues :
1 - Timezone Mismatch:
The time picker uses my local timezone (Europe/UTC+1), but the database saves in UTC.
This causes scheduling issues: If I select 12:00, it’s saved as 11:00, and the system shows it as published an hour earlier .
2- Should the status (e.g., "published") update automatically when the time is reached, or should I handle it with a cron job?
3- What is the best practice ,
Should times like publish_start_date be stored in DB "mysql" in UTC or my local timezone?
1- Uncommented publish_start_date and publish_end_date in the migration.
Added them to the $fillable property in my model.
2- Cast these fields to datetime to avoid the DB error
My issues :
1 - Timezone Mismatch:
The time picker uses my local timezone (Europe/UTC+1), but the database saves in UTC.
This causes scheduling issues: If I select 12:00, it’s saved as 11:00, and the system shows it as published an hour earlier .
2- Should the status (e.g., "published") update automatically when the time is reached, or should I handle it with a cron job?
3- What is the best practice ,
Should times like publish_start_date be stored in DB "mysql" in UTC or my local timezone?
