Dateadd in SQL :
SELECT Dateadd(hour, -7, [DateProcess]) AS [DateProcess]
, [Id] AS Recid
,[Linenum] as Linenumber
,[ItemNumber]
,[Quantity]
,[Warehouse]
,[WBNumber]
,[Storage]
,[UOM]
,[ModulIplant]
,[DataAreaID]
FROM [DB_Staging].[Distribution].[WBDRubberDetails]
OR
CONVERT(VARCHAR(10), [DateProcess], 111) AS DateProcess
SELECT Dateadd(hour, -7, [DateProcess]) AS [DateProcess]
, [Id] AS Recid
,[Linenum] as Linenumber
,[ItemNumber]
,[Quantity]
,[Warehouse]
,[WBNumber]
,[Storage]
,[UOM]
,[ModulIplant]
,[DataAreaID]
FROM [DB_Staging].[Distribution].[WBDRubberDetails]
OR
CONVERT(VARCHAR(10), [DateProcess], 111) AS DateProcess
0 comments:
Post a Comment