thanks everyone. The script worked fine with the convert function.

I need to convert an nvarchar timezone field to bigint. Can anyone quickly tell me the solution to this as my nvarchar field contains timezone values like this --> GMT-05:00

looking forward for a prompt response.