Forum Discussion
MarcusMM
Jan 02, 2026Copper Contributor
SYSUTCTRANSBEGINTIME
what about SYSUTCTRANSBEGINTIME with datetime2(7) in SQL Server 2025?
carlwalk
Jan 08, 2026Brass Contributor
I don’t think SYSUTCTRANSBEGINTIME column exists , checked SQL Server 2025 docs, nothing there.
You can try this
SELECT
transaction_id,
CAST(transaction_begin_time AS datetime2(7)) AS precise_time
FROM sys.dm_tran_active_transactions;
MarcusMM
Jan 18, 2026Copper Contributor
To clarify: I Ise SYSTEM_VERSIONING with ValidFrom datetime2(7) and ValidTo datetime2(7)
SQL Server fills ValidFrom with the Transaction start Time, I want to have a function to retrieve that value (datetime2(7))
Reagards Marcus