I have several client applications (Excel VBA) updating a SQL Server 2008 database from different parts of the world. I have a column for DateTime in DateTime data type. I want to rationalise the DateTime so that a ordering the data in DateTime sequence will be correct. ie. because local time where the users will input from will be different.
So I have decided to use GMT as the standard.
I have these challenges:
(1) To convert local time to GMT.
(2) My server is in the USA. Therefore the data format will need converting?
Any pointers will help me progress. Thanks.