Sql-server – Is MSMerge_History.time in GMT or local server time

merge-replicationreplicationsql server

Is the time column in the MSMerge_History table GMT or local distribution server time?

Best Answer

The MSmerge_history table does have a column named time and it's of the type datetime, it just isn't documented.

To answer your question, based on my tests it appears to be local server time. The time column has a default value of getdate().