Comments by dnomyar (Top 1 by date)

As far as I am aware, the T-SQL function getdate() gives the wallclock local time irrespective of whether the local time is in standard time or summer time. Therefore, there is no need to make any special provision for summer time.

This can easily be verified by executing the query:

SELECT getdate()

Also, using a computed field for the local time as done by Panayotis, is very convenient when viewing the raw underlying table.