Link to home
Start Free TrialLog in
Avatar of hindersaliva
hindersalivaFlag for United Kingdom of Great Britain and Northern Ireland

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.
ASKER CERTIFIED SOLUTION
Avatar of chaau
chaau
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of hindersaliva

ASKER

Hi, both ideas very useful for me.

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