I have the following string:
2024-07-01T00:00:00.000+00:00
I wish to convert it to MM/dd/yyyy
I have tried the following SQL:
CAST (SUBSTRING(ESTIMATED_DISPATCH,1,4) + '/' + SUBSTRING(ESTIMATED_DISPATCH,6,2) + '/' + SUBSTRING(ESTIMATED_DISPATCH,9,2) AS date) AS estimated_dispatch
I am getting the error:
Msg 241, Level 16, State 1, Line 1
Conversion failed when converting date and/or time from character string.
Can someone guide me on the correct way to convert this to a date
DECLARE @InString VARCHAR(30)='2024-07-01T00:00:00.000+00:00';
SELECT CONVERT(CHAR(10),CAST(@InString AS DATE),101);
Please try this