Drupal timezone and database I have a content type with datetime field. When I save node, in database I have 2014-04-28 11:00:00 for instance. But when I edit the node i have 2014-04-28 13:00:00. I guess that it has something to do with timezones. 

Now the problem is that i have lot of nodes and i have to get the time from database. I don't want to node_load or anything like that. 

The question is - is it possible to extract 2014-04-28 13:00:00 datetime from database with MySQL query? Or any work around where I don't have to use node_load?

Any input will be appreciated :)
What version of Drupal is this?

It's against best practices to go directly to the database but if you really need to I don't see why you can't query the field's table. What problems are you having? 

When entering data for a field, the data entered is assumed to be in the site's time zone. When the data is saved to the database, it is converted to UTC. When retrieved from the database, the data is converted to the Site's time zone for anonymous users or the User's time zone for logged in users when User-configurable time zones is enabled.

You may wanted to use format_date to convert your time.
See: https://api.drupal.org/api/drupal/includes!common.inc/function/format_date/7

UPDATE:

I don't know what source you time is in, either a timestamp or formatted date/time. In your example you're using  2014-04-28 11:00:00 so lets convert that to a unix timestamp:

  $newdate = new DateTime('2014-04-28 11:00:00 UTC', new DateTimeZone(date_default_timezone_get()));
  $unixts = $newdate-&gt;getTimestamp();
  $siteDate = format_date($unixts, 'small', '', date_default_timezone_get());