DataTime for linked Server
I have a SQL server in Country A (Server A) and another Server in Country B (Server B) Server A has Server B as linked server, I run a stored procedure in Server A and getdate()gives me current date/time for Server A, how can I do getdate() for Server B?
The Getdate() on ServerB might not be the same as ServerA and can cause conflicts for time sensitive data/logic.
Generally for applications spanning countries and timezones it is advised to use UTC time getUTCDate() instead of getdate(). Any localized information to the user can be done by converting the UTC time into local timezone.
|||Ok. Thanks, how can I convert UTC to local time?
|||
you can use any of the date functions - DateAdd, DateDiff etc..
