Databases
StackOverflow2013
Postsdbo
POGoogle Calendar Daylight saving 1 hour
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POGoogle Calendar Daylight saving 1 hour
    primarykey
    data
    text
    <p>I am trying to retrieve event of google calendar for today and display in a web page. But the google calendar only display the event after 1 hour i.e. 1:00. Even though I have tried to set timezone as "Europe/Berlin" it is still not working.</p> <pre><code>&lt;?php // load library require_once 'Zend/Loader.php'; Zend_Loader::loadClass('Zend_Gdata'); Zend_Loader::loadClass('Zend_Gdata_ClientLogin'); Zend_Loader::loadClass('Zend_Gdata_Calendar'); Zend_Loader::loadClass('Zend_Http_Client'); // create authenticated HTTP client for Calendar service $gcal = Zend_Gdata_Calendar::AUTH_SERVICE_NAME; $user = "email@gmail.com"; $pass = "password"; $client = Zend_Gdata_ClientLogin::getHttpClient($user, $pass, $gcal); $gdataCal = new Zend_Gdata_Calendar($client); $query = $gdataCal-&gt;newEventQuery(); $query-&gt;setUser('default'); $query-&gt;setVisibility('private'); $query-&gt;setProjection('full'); $query-&gt;setOrderby('starttime'); date_default_timezone_set('Europe/Berlin'); $query-&gt;setStartMin(date('Y-m-d 00:00:00')); $query-&gt;setStartMax(date('Y-m-d 23:59:59')); $eventFeed = $gdataCal-&gt;getCalendarEventFeed($query); ?&gt; &lt;div class='container display-toggle'&gt; &lt;ul&gt; &lt;? foreach ($eventFeed as $event) { ?&gt; &lt;li&gt; &lt;ul&gt; &lt;? foreach ($event-&gt;when as $when) { $startDateTime = new DateTime($when-&gt;startTime); ?&gt; &lt;li class='body-watch-logo' data-event="&lt;? echo $event-&gt;id; ?&gt;" data-time="&lt;? echo $when-&gt;startTime; ?&gt;"&gt;&lt;/li&gt; &lt;li&gt;&lt;h3&gt;&lt;? echo $startDateTime-&gt;format('H:i'); ?&gt;&lt;/h3&gt;&lt;/li&gt; &lt;li&gt; &lt;div class='span8 pull-left'&gt; &lt;div class='text-box'&gt; &lt;h5&gt;&lt;? echo $event-&gt;title-&gt;text; ?&gt;&lt;/h5&gt; &lt;/div&gt; &lt;div class='text-box'&gt; &lt;h4&gt;Find them at: &lt;/h4&gt; &lt;p&gt;&lt;? echo $event-&gt;where[0]; ?&gt;&lt;/p&gt; &lt;/div&gt; &lt;div class='text-box'&gt; &lt;h4&gt;description: &lt;/h4&gt; &lt;p&gt;&lt;? echo $event-&gt;content; ?&gt;&lt;/p&gt; &lt;/div&gt; &lt;/div&gt; &lt;/li&gt; &lt;? } $count++; ?&gt; &lt;/ul&gt; &lt;hr&gt; &lt;/li&gt; &lt;? } ?&gt; &lt;/ul&gt; </code></pre> <p>The problem is when I show the events it does not show the events on 00:00 to 1:00. </p> <p>For today's event the list starts after 1:01. This is because of the daylight saving problem. </p> <p>I have put the timezone in google calendar as Berlin and also in the page as Berlin. But still the events at 00:00 to 1:00 is not showing today.</p> <p>Please help me.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USSimon H
    1. USAlok Pant
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. CO`"it is still not working"` In what way is it not working? You don't give us much to go on.
      singulars
      1. POGoogle Calendar Daylight saving 1 hour
      1. USvascowhite
    2. COIf I have a event at 1 o'clock in the morning then it shows in yesterday's event list... Today event list only starts after 1:01 am.
      singulars
      1. POGoogle Calendar Daylight saving 1 hour
      1. USAlok Pant
    3. COWhat TZ is your google calendar set to?
      singulars
      1. POGoogle Calendar Daylight saving 1 hour
      1. USvascowhite
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload