Support

November 8, 2017 at 4:34 pm

Hi Josh

Well I think I spent several hours today reading those great docs on EE Models and Date times etc.

I have a simple query now working and displaying events but the timezone is all wrong. Its fine on the main site on the upcoming events widgets, shortcodes but not in my test code.

I am in UK so GMT timezone. My server is in Chicago and I have WordPress set to America/Chicago timezone.

So I just created an event to start at 08:00 am. In the SQL table it is stored as 2017-11-25 14:00:00. Chicago is 6 hours behind GMT so I guess as per the docs worpdress stores the date as GMT time.

In my code i’m doing this to simply show events between two dates….

EEM_Event::instance()->show_next_x_db_queries(1); //output SQL

$events = EEM_Event::instance()->get_all(
                array(
                    array(
                        'Datetime.DTT_EVT_start*1' => array('<', new \EventEspresso\core\domain\entities\DbSafeDateTime('2017-12-19 00:01', new DateTimeZone('America/Chicago'))),
                        'Datetime.DTT_EVT_start*2' => array('>', new \EventEspresso\core\domain\entities\DbSafeDateTime('5 days ago', new DateTimeZone('America/Chicago')))
                    )
                )
            );
echo "<br><br><br>";
foreach( $events as $event ) {
	
	$datetime = $event->get_first_related( 'Datetime' );
	
	echo $event->name()."<br>";
	echo $datetime->get_i18n_datetime( 'DTT_EVT_start', 'M d, Y H:i'  )." (".$event->get_timezone().")<br><br>";
}

It’s working but the SQL date times don;t match what I’m asking, notice here the SQL outputs a time of 06:01:00 when I used 00:01 in my code. so again this is out by 6 hours the wrong way so looks like its showing that time in GMT?

AND Datetime.DTT_EVT_start < '2017-12-19 06:01:00' AND Datetime.DTT_EVT_start > '2017-11-03 22:20:48'

and when the events are displayed they show timezone in use is correct America/Chicago but the time of the event instead of 08:00am shows as 02:00am? I could understand if it showed 14:00 as per the SQL table GMT time but this is showing 6 hours the wrong way.

BRC Clarksville
Nov 18, 2017 02:00 (America/Chicago)

Please help me to realise what I;m doing wrong in terms of timezones here 🙂

Thank you so much

Jonathan

November 9, 2017 at 2:45 am

Hi Josh

Ahh I’ve seen all the great code snippets you’ve put out there…..so am pretty sure you know your stuff 🙂

I’m not trying anything complicated here just to display some events between two start dates using the code supplied in your plugin docs.

My query is do you have any idea why when I submit a query with this date time

DbSafeDateTime(‘2017-12-19 00:01

the actual SQL generated by EE is showing a different time of 6 hours difference?

Datetime.DTT_EVT_start < ‘2017-12-19 06:01:00’

it must be a simple timezone issue so am i missing something form the few lines of code above to get this in to the correct timezone?

Thanks…. if you can’t hep on this simple query I’ll have to post on github.

Jonathan