Future Events Past Daylight Savings Time Change

[lespyd]

Hi everyone,

First, I just starting using CiviCRM and I think it's great and thanks to the team for creating such an awesome tool.

Now the problem I'm having is that I'm creating events in the far future, past the November Daylight savings time change. In CiviCRM, the times remain the same, but on my frontpage, the events after the first sunday of November are 1 hour early. (I'm using a Views2 to display an event list on the frontpage). That being said, here's my views template file, displaying the incorrect time.

Code:

<?php 
$unixtimetstart =$row->civicrm_event_start_date;
$unixtimetend =$row->civicrm_event_end_date;
$realtimetstart =date("g:ia", $unixtimetstart);
$realtimetend =date("g:ia", $unixtimetend);

if(empty($unixtimetend))
print "$realtimetstart";
else
print "$realtimetstart &ndash; $realtimetend";
?>

From what I gather, CiviEvent stores the times in unix time, so for themeing purposes, I converted the raw SQL data to real time. When I create the actual event in the civicrm admin, I choose 11/4/10 4:00pm from the form. When I go to the actual civicrm event page, the time is correct. It's only when I grab the raw sql data and convert it to real time that throws it off an hour. This doesn't happen to events before November. Any thoughts? Am I not supposed to grab the raw data?

[Donald Lobo]

civicrm stores the time in the DB format and not unix time

not sure if the above helps u or not maybe the views2 code does some DST manipulation?

lobo