Tag Info

New answers tagged


If you just need this for a one-time query, I'd recommend something like this: WITH AdjustedVehicleInfo AS ( SELECT DATEADD(HOUR, -7, Timestamp) AS MST_Timestamp FROM Vehicle ) SELECT MST_Timestamp FROM AdjustedVehicleInfo WHERE MST_Timestamp BETWEEN @StartDate AND @EndDate where @StartDate and @EndDate are set to MST times. The reason I put ...

Top 50 recent answers are included