Skip to navigation
Mssql get one year back date
01.09.14
DECLARE @d varchar(10) = CONVERT(VARCHAR(8), GETDATE()-365, 112) print @d the output will is: 20130901
http://www.sql-server-helper.com/tips/date-formats.aspx
Reply
Anonymous
SELECT TOP (1000) [yz3_location] ,[yz3_style] ,[yz3_qty] ,CONVERT(VARCHAR(8),[date],112) as d ,sl_repl_trans.dbo.send_stock_over_url(yz3_style,yz3_qty,date ) AS success FROM [SL_repl_trans].[dbo].[yz3_stock_h]
01.09.14
Reply
Anonymous
Information Epoch 1747269926
Small is beautiful.
Home
Notebook
Contact us
