December 31, 2018 at 7:02 am
Is there any possibilities on change the Return Datetime of sys.fn_cdc_map_lsn_to_time(__$start_lsn
We will have to show modified date of transactions using CDC sys.fn_cdc_map_lsn_to_time(__$start_lsn)
Thanks
Ram
January 2, 2019 at 2:58 am
Is there any possibilities??
January 2, 2019 at 9:24 am
sram24_mca - Wednesday, January 2, 2019 2:58 AMIs there any possibilities??
You are talking about modifying a Microsoft system object, not sure I would want to if I could. Best bet is to wrap the call in a function that does the conversion to UTC.
January 6, 2019 at 10:42 pm
Lynn Pettis - Wednesday, January 2, 2019 9:24 AMsram24_mca - Wednesday, January 2, 2019 2:58 AMIs there any possibilities??You are talking about modifying a Microsoft system object, not sure I would want to if I could. Best bet is to wrap the call in a function that does the conversion to UTC.
Can you just explain about this Best bet is to wrap the call in a function that does the conversion to UTC
January 7, 2019 at 8:22 am
sram24_mca - Sunday, January 6, 2019 10:42 PMLynn Pettis - Wednesday, January 2, 2019 9:24 AMsram24_mca - Wednesday, January 2, 2019 2:58 AMIs there any possibilities??You are talking about modifying a Microsoft system object, not sure I would want to if I could. Best bet is to wrap the call in a function that does the conversion to UTC.
Can you just explain about this Best bet is to wrap the call in a function that does the conversion to UTC
I don't know, after looking at the Microsoft Docs perhaps something like this:SELECT TODATETIMEOFFSET(sys.fn_cdc_map_lsn_to_time(__$start_lsn), DATEPART(TZOffset, SYSDATETIMEOFFSET()));
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy