As Alessandro said above, data is written to the DB in GMT+0. For you SQL select statement, you want to have something like this included in your query for dates.
dateadd(hour, @gmt,dbo.alerts.LoggedTime) as 'Created Date'
You want to set @gmt to your timezone. In my case it's 2.