Timezones and Date(time) comparisons on Amazon Cloud

Timezones and Date(time) comparisons on Amazon Cloud

  
Don't forget to set the correct Timezone on the Amazon instances ... !!

Let's say one of my Amazon instances is running in the US (with default US timezone setting)
DateTime is several hours behind my local time (NL).

If I want to see for instance tasks due now, how do I proceed ... ?
The task is added to the database with an end datetime in NL timezone, server however is running in US timezone.
So the tasks will not appear in the list.

Remember to set the timezone :-)