It is an application database used for reporting purposes, where I need to calculate datetime out of two integer columns (till last week, I calculated only date but new requirement asks for date and time). However, these int columns get data from msdb.dbo.sysjobservers as source table.
This function msdb.dbo.agent_datetime(@int1, @int2) is helpful for me in both ways:
1. I applied for my immediate reporting purposes
2. I added a datetime column in my table, updated column for current data and used this function in SSIS package.
All solutions are good but built-in function is new learning & quick for me.
I appreciate each of you for your responses.
Every thought is a cause and every condition an effect