How are you generating the audit trail?

EDIT: If you know the timezone, then you should know the offset. Use TODATETIMEOFFSET:

http://msdn.microsoft.com/en-us/library/bb630335(v=sql.100).aspx