SQL Server 2012 Enterprise
I'm restoring a full database backup taken at Midnight CST, and running the following query:
select chg.ID, chg.Sys_Change_Version, chg.SYs_ChangeOperation, tct.commit_time
from changetable(changes tblPS_SCHEDULES_Details_CellInfo, 0) chg inner join
sys.dm_tran_commit_table tct on chg.Sys_Change_Version = tct.commit_ts
After converting Commit_Time
from UCT to CDT, I'm getting times way past the midnight time when the full backup was taken. I"m actually getting current time stamps.
Can anyone help explain what is happening here?
I was hoping to use sys.dm_tran_commit_table
to get the date/time that the change occurred per other forums, but when processing from a backup file, this doesn't give me realistic times.