hindersaliva
asked on
SQL insert DateTime UK and US
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I decided to go with a default value for the column . ie. GetDate() for the moment. So I shall store the server's date/time.
Thanks