Adjusting to user's local time

Hi,

I have a notification I'm sending out, and I'm storing an expiration
date as UTC. I'd like to format this to the user's local time based
on the subscriptions timezone setting.

I can figure out how to do this, but I'd be tapping into NS' timezone
tables and I'd like to confirm that this is an appropriate way to
handle this task.

Thanks
Andy

Hello Andy:

Why not do this:

[Expiration in Local Time] = DateAdd(hour, DateDiff(hour, GETUTCDATE(),
GETDATE()), [Expiration in UTC Time])

One caution: This only applies to records where the [Expiration Date] is in
the same Daylight Savings timeframe as the current date. In other words, this
is accurate if you are looking at an [Expiration Date] coming up in a week.
But if you are looking at an [Expiration Date] that will be in, say, November
or December (after the U.S. has gone off Daylight Savings Time) then you will
be off by one hour.

The choice is yours: If that one hour difference is acceptable for 6 months
out of the year, then it will work. If not, you will need to figure out
something else.

Best of luck.

HTH

--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"Andy" wrote:

> Hi,
>
> I have a notification I'm sending out, and I'm storing an expiration
> date as UTC. I'd like to format this to the user's local time based
> on the subscriptions timezone setting.
>
> I can figure out how to do this, but I'd be tapping into NS' timezone
> tables and I'd like to confirm that this is an appropriate way to
> handle this task.
>
> Thanks
> Andy
>
>