It sounds like you're using a trigger, which won't have a clue as to what timezone the client is located.

Since you already have the timezone offset, don't use GETDATE. Use the offset function I listed above.