Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!
create function dtUtc2Local(@dtUtc datetime)returns datetime as --Parameter: UTC datetime --returns: Corresponding local time begin DECLARE @TimeDiff int Declare @dtLocal as datetime --get time difference SET @TimeDiff = DATEDIFF(hh, GETUTCDATE(), GETDATE()) SELECT @dtLocal = DATEADD(HH, @TimeDiff, @dtUtc) return @dtLocal END
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Pivot Query Problem||9||49|
|How can i use WITH CTE for checking exist value?||3||55|
|Why i am getting a star, SSMS does not show me any error. Division Error||5||38|
|Find unused columns in a table||12||68|