I am developing a small issue management system where all our own company user from our various branches will post issues. from the server side i will call a store proc which will insert issues info into table and i will also send server side date & time to store proc and i want to know how could i convert server side date & time to UTC date & time and store in sql server table.
second scenario. when user read data then again i will send user time zone info to store proc and store proc will convert utc date & time to local time as per user time zone info.
1) so please show me how could i convert server side date & time to UTC date & time and store in sql server table
2) how to convert UTC date & time to user local time as per user's time zone info in my store proc.
please answer for my 2 points. thanks