Mountain Standard Time
DateTime snapshotDateUtc = snapshotDate.ToUniversalTime().AddHours(5).AddMinutes(30); //TimeZoneInfo tzi = TimeZoneInfo.FindSystemTimeZoneById("Mountain Standard Time"); //DateTime localTime = TimeZoneInfo.ConvertTimeFromUtc(utcTime, tzi);
SELECT ISH.BinLocation AS [BinLocation], I.ItemName, I.[Description], ISH.QuantityInStock, CAST( ( CAST(I.BoxLength AS DECIMAL) * CAST(I.BoxHeight AS DECIMAL) * CAST(I.BoxWidth AS DECIMAL) * CAST(ISH.QuantityInStock AS DECIMAL) ) / @CubicInchToCubicFeetConversionFactor AS DECIMAL(18,2) ) AS [ItemVolumeCF], I.BoxLength, I.BoxHeight, I.BoxWeight, I.StatusEnum,ISH.SnapshotDate FROM Item AS I inner join InventorySnapshot AS ISH ON I.Id =ISH.ItemId and ISH.SnapshotDate=CAST(@SnapshotDate AS DATE)
<pre lang="SQL"><pre lang="SQL">
Time zone mountain standard time
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)