I was trying to capture NOW in PDT in the Code Before Store type field, but the trf_submit_datetime field still records UTC after I check the database record. Hmm... or is there a better way? Thx
$pdt = new DateTimeZone('America/Los_Angeles');
$now_utc = new DateTime('now', $utc);
$now_utc->setTimeZone($pdt);
$fields['trf_submit_datetime']->value = $now_utc->format('Y-m-d H:i:s');
I also considered doing a search / list template override, but this seems it's NOT possible -- true?
Value set in beforestore should be also the one the is recorded. Did you by any chance use it on the calendar field? If this is the case I would suggest that you use hidden text field instead.
Yes, it is the calendar field and it is hidden. What's strange it works in the template, but the actual recorded date/time in the database is NOT correct. Very perplexing.
Do you know where Joomla gets it's UTC time from? Is it php.ini? is it from the control panel? in our case it's Plesk.
It seems Seblod should just add an OFFSET parameter to the calendar plugin.
If you want to store exact value you need to use text field, calendar field does transformations, value in database is always save in UTC (it is converted from input value to UTC and back when it is displayed using server timezone and user timezone set in Joomla).