Timestamp Timezone Problem

[offizium-berndstorath]

I get this in phpmyadmin

time	created_at
2024-04-22 00:40:11	2024-04-22 00:40:11

I get this using xdebug $model->created_at->toString();

time	created_at
Mon Apr 22 2024 00:40:11 GMT+0200	Mon Apr 22 2024 00:40:11 GMT+0200

I get this when calling the api

time	created_at
2024-04-22T02:40:09.000000Z	2024-04-22T00:40:09.000000Z

casts are

$casts = [
  'time' => 'datetime:Y-m-d\TH:i:s.u\Z',
  'created_at' => 'datetime:Y-m-d\TH:i:s.u\Z'
];

mysql and config timezones are +2 and Europe/Berlin respectively. Both are mysql data type TIMESTAMP

When setting the mysql timezone to utc this problem doesnt exist anymore. But this is not the fix i am hoping for

Why do the two times suddenly differ?

[ghost]

Set your timezone in laravel

/*
|--------------------------------------------------------------------------
| Application Timezone
|--------------------------------------------------------------------------
|
| Here you may specify the default timezone for your application, which
| will be used by the PHP date and date-time functions. We have gone
| ahead and set this to a sensible default for you out of the box.
|
*/

'timezone' => 'UTC',

[ghost]

your time may be the updated at for some fields?

[offizium-berndstorath]

Why would it be? My full table schema already has a updated_at column

[ghost]

I just asked because you did not mention until now updated at. So next question then would be how are you populating the time column? Using timestamps = true in your model will auto-fill ONLY the updated_at and created_at which I see are ok on your side.

[offizium-berndstorath]

I am using $table->timestamps(); in the migration.time is a from something different. but because of timings most of the time the same as created_at

[ghost]

I updated my first element
then the list became:

So the first row was created with UTC. Then I changed the timezone in laravel to + 3 h

then I updated that row and I replicated your behaviour in the hours area (not seconds)

// dd(Timestamp::find(13876)->update(['time'=>now()]));
dd(Timestamp::all()->toArray());