Hello,
All time values stored in the NS databases are represented in UTC. This
prevents issues that arise from daylight savings time transitions. You
cannot change how times are stored, but you can of course calculate what the
local time would be when querying.

To convert to local time, you need to figure out what the time difference
between your local time and UTC time is. You can do this as follows:

DECLARE @hourDifference INT

SELECT @hourDifference = DATEDIFF(HOUR, GETUTCDATE(), GETDATE())

SELECT DATEADD(HOUR, @hourDifference, SentTime) AS LocalSentTime

FROM NS<NotificationClassName>NotificationDistribution

Hope this helps.
-shyam
--
Learn more about SQL-NS:
http://www.amazon.com/exec/obidos/tg/detail/-/0672326647/
---------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
---------------------------------------------
[quoted text, click to view]