Comments by Panayotis Matsinopoulos (Top 2 by date)

Panayotis Matsinopoulos 30-Dec-11 16:47pm View

Deleted

You are absolutely right and thank you very much for your comment. I have updated the article to reflect your comment. I will try to think of a way to improve and cover Daylight Saving in cases this is possible. Thanks again.

Panayotis Matsinopoulos 30-Dec-11 6:28am View

Deleted

Here is a select that can help you understand it:

<pre>
select top 1 a.CreatedOn as utc_created_on,
dateadd(hour, datediff(hour, getutcdate(), getdate()), a.CreatedOn) as local_created_on,
getutcdate() as utc_current,
getdate() as local_current,
datediff(hour, getutcdate(), getdate()) as local_time_zone_utc_offset
from New_FlightReservationBase a order by a.CreatedOn desc;
</pre>

It is from a production database that I use. The system is in Greece, 2 hours offset from UTC.

The result of running this query is:

<pre>
utc_created_on local_created_on utc_current local_current local_time_zone_utc_offset
----------------------- ----------------------- ----------------------- ----------------------- --------------------------
2011-12-30 11:26:00.000 2011-12-30 13:26:00.000 2011-12-30 11:26:46.250 2011-12-30 13:26:46.250 2

(1 row(s) affected)

</pre>

Is that helpful?