Search code examples
sql-serverdatetimetransactionstransactional-replication

Transactional replication: Getdate() column shows future time in both publisher and subscriber tables

In my project I have to replicate a table from one server on to other. While replicating everything works except a column that is meant to show getdate() which actually shows a future time. For example when a record is saved in the publisher table it is being saved with a time that is 4 hours ahead. I am pretty sure that this issue is because of my replication set up on the table but unable to find a fix. Can anyone please help me fix this issue? Thanks

Solution

  • Turns out this is not an issue with replication the future date was because the stored proc has getUTCdate() and not the getdate().