Discrepancies in Dates (Published/Created/Modified)

[eduardomart]

This is a brand new record I created:

Notice the Created and Modified dates are identical, all good, except it is currently Feb. 16, 4:08 PM here. (Please ignore the exact minute as there are slight differences between my testing and with the screengrabs etc)

So I went to config.yaml and set my timezone:

timezone: America/Los_Angeles

So now I go back and try to create a record again:

The Modified time is correct, but not the Created time (this is now 8 hrs behind)

To further complicate things, once the record is saved:

Published time is correct, but Created and Modified date/times are now both 8hrs behind

Now for the front end, in my template I have this:

Created: {{ record.createdAt|localedatetime("%A %B %e, %Y | %H:%M") }}
<br>
Pub: {{ record.publishedAt|localedatetime("%A %B %e, %Y | %H:%M") }}
<br>
Mod: {{ record.modifiedAt|localedatetime("%A %B %e, %Y | %H:%M") }}

They all show the 8hr ahead difference, even though I have the correct timezone set in config.yaml

If I output {{ "now"|date("m/d/Y | g:i a") }} I do get the actual current date/time.

🤯

--

Bolt 4.1.13

[I-Valchev]

Hi @eduardomart , I thought we had fixed that in #1901....

Still, one thing I am noticing is the use of localedatetime over localdatetime (note the missing e). The former is deprecated, the latter is the one that should be used. They most likely behave differently.

Can you show the output then?

Would be really helpful if you can dig deeper into what's happening in the localdate filter:

core/src/Twig/LocaleExtension.php

Lines 165 to 195 in e8a597d

	public function localdate($dateTime, ?string $format = null, ?string $locale = null, ?string $timezone = null): string
	{
	if ($dateTime instanceof \Datetime) {
	$dateTime = Carbon::createFromTimestamp($dateTime->getTimestamp(), $dateTime->getTimezone());
	} elseif (empty($dateTime)) {
	$dateTime = Carbon::now();
	} else {
	$dateTime = Carbon::createFromTimeString($dateTime);
	}
	if ($format === null) {
	$format = $this->config->get('general/date_format');
	}
	if ($locale === null) {
	$current = $this->getHtmlLang($this->twig);
	$locale = ! empty($current) ? $current : $this->defaultLocale;
	}
	if ($timezone === null) {
	$timezone = $this->config->get('general/timezone', null);
	}
	if ($timezone !== null) {
	$dateTime->setTimezone(new CarbonTimeZone($timezone));
	}
	$dateTime->locale($locale);
	return $dateTime->translatedFormat($format);
	}

Might also be helpful to check what's stored in the database, and what this does:

core/src/Entity/Content.php

Lines 369 to 372 in e8a597d

	public function getCreatedAt(): ?\DateTime
	{
	return $this->convertToLocalFromDatabase($this->createdAt);
	}

core/src/Entity/Content.php

Lines 672 to 687 in e8a597d

	/**
	* All date/timestamps are stored in the database in UTC. When retrieving
	* them, we get the timestamp as-is in the DB with the current local
	* timezone slapped onto it. This method converts it back to UTC, and
	* then re-applies the current local timezone to it.
	*/
	private function convertToLocalFromDatabase(?\DateTime $dateTime): ?\DateTime
	{
	if (! $dateTime) {
	return null;
	}
	$dateTimeUTC = new \DateTime($dateTime->format('Y-m-d H:i:s'), new \DateTimeZone('UTC'));
	return $dateTimeUTC->setTimezone($dateTime->getTimezone());
	}

The correct behaviour would be for DateTime to be stored in UTC, and then converted to whatever it needs to be at runtime. That's one of the things that's quite difficult to reproduce consistently, so if you can look into things using these pointers above, that'd be fantastic 🙏

[I-Valchev]

@eduardomart any luck in seeing where the weirdness is coming from?

[oto-emo]

Hi,

Indeed, during the construction of content entity, createdAt property is instantiated without going through setCreatedAt() method and therefore without convertToUTCFromLocal() method :

core/src/Entity/Content.php

Line 155 in 5fca72a

$this->createdAt = new \DateTime();

This results in a date at UTC default instead of configured UTC (here Europe/Paris).

Two solutions :
Use convertToUTCFromLocal() method in constructor :
$this->createdAt = $this->convertToUTCFromLocal(new \DateTime());

Or use setCreatedAt() method in constructor :
$this->createdAt = $this->setCreatedAt(new \DateTime());