SQL Server AutoDate

Question

I have my server in US and my client is in India, the problem is when he is inserting data there is a autoDate inside MSSql Table, but as the server is in different time zone, We are getting date with 12Hours different, how to overcome it.

Date in Table is AutoDate GetDate()

Regards

Store the dates in UTC format and while retrieving display based on the time zone... — sajoshi, Apr 11 '11 at 07:35

score 0 · Accepted Answer · edited May 23 '17 at 12:04

0

Use of UTC format may solve your issue. Please refer to these links

edited May 23 '17 at 12:04

Community

1
1

answered Apr 11 '11 at 07:41

Nirmal

1,223
18
32

score 0 · Answer 2 · answered Apr 11 '11 at 08:29

How about changing your default constraint and rely on GETUTCDATE() instead of GETDATE()? This would solve your issue from the storage perspective.

You'd have to slightly alter your html rendering as well, in order to generate the date in a user friendly format, taking into account the user's timezone.

SQL Server AutoDate

2 Answers2