Hi, We get some data in flat files and need to convert date in text format to "mm/dd/yyyy". For instance "Sat May 30 2020 14:19:55 GMT-0700 (Pacific Daylight Time)" is formatted as "05/30/2020".
SQL Server version 2016.
DECLARE @processdata TABLE (
[ProcessDate] nvarchar(255) NOT NULL);
INSERT @processdata
SELECT 'Sat May 30 2020 14:19:55 GMT-0700 (Pacific Daylight Time)';
Resultset:
05/30/2020
Thank you