SELECT [id] ,[eta] ,CONCAT(SUBSTRING(CAST([eta] AS varchar(255)),0,5), SUBSTRING(CAST([eta] AS varchar(255)),7,2), SUBSTRING(CAST([eta] AS varchar(255)),5,2) ) AS d FROM [SL_planning_module].[dbo].[supplier_orders_etas] /* UPDATE [SL_planning_module].[dbo].[supplier_orders_etas] SET eta = CONCAT(SUBSTRING(CAST([eta] AS varchar(255)),0,5), SUBSTRING(CAST([eta] AS varchar(255)),7,2), SUBSTRING(CAST([eta] AS varchar(255)),5,2) ) */

https://docs.microsoft.com/en-us/sql/t-sql/functions/substring-transact-sql?view=sql-server-2017

same with condtions: UPDATE [SL_planning_module].[dbo].[supplier_orders_etas] SET eta = CONCAT(SUBSTRING(CAST([eta] AS varchar(255)),0,5), SUBSTRING(CAST([eta] AS varchar(255)),7,2), SUBSTRING(CAST([eta] AS varchar(255)),5,2)) WHERE SUBSTRING(CAST([eta] AS varchar(255)),5,2) > 12 28.11.18

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2024