sql server - Converting "Tue Feb 18 00:00:00 CST 2025" to Date - Stack Overflow

admin管理员组

文章数量:1344188

I have a column in SQL Server table that I has date values as "Tue Feb 18 00:00:00 CST 2025". When I look at BOL, it doesn't show me a convert function that I can use directly with this. Do I need to substring or other functions to convert this to a report usable format?

I have a column in SQL Server table that I has date values as "Tue Feb 18 00:00:00 CST 2025". When I look at BOL, it doesn't show me a convert function that I can use directly with this. Do I need to substring or other functions to convert this to a report usable format?

• sql-server
• t-sql

Share Improve this question Follow edited 7 hours ago Dale K 27.5k1515 gold badges5858 silver badges8383 bronze badges asked 7 hours ago rvphxrvphx 2,39299 gold badges4242 silver badges7474 bronze badges 4

• Approach it like you would any other development problem you've been tasked to solve, work out some way to use the tools available to accomplish what you want in a series of steps. There are loads of questions out there about converting dates. And you don't even say what a "report usable format" is. – Dale K Commented 7 hours ago
• 3 While asking a question, you need to provide a minimal reproducible example: (1) DDL and sample data population, i.e. CREATE table(s) plus INSERT T-SQL statements. (2) What you need to do, i.e. logic and your code attempt implementation of it in T-SQL. (3) Desired output, based on the sample data in the #1 above. (4) Your SQL Server version (SELECT @@version;). – Yitzhak Khabinsky Commented 6 hours ago
• 4 Please note that this site is not a code-writing service. We can help you with specific questions about your code, ideally accompanied by an MCVE. – Bohemian ♦ Commented 6 hours ago
• I appreciate the comments, but I was simply asking for advice on how to approach the problem and not actually looking for coding help. I looked at Books online and did not find an answer so thought I would try and ask for help which apparently is not what this site is meant for. Thanks again for taking the time to read. – rvphx Commented 13 mins ago

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

Please try the following solution based on tokenization via JSON.

The actual date is composed based on appropriate tokens from a JSON array.

SQL

-- DDL and sample data population, start
DECLARE @tbl TABLE (ID INT IDENTITY PRIMARY KEY, col VARCHAR(30));
INSERT INTO @tbl (col) VALUES
('Tue Feb 18 00:00:00 CST 2025'),
('Tue Apr 03 00:00:00 CST 2024');
-- DDL and sample data population, end

SELECT * 
    , TRY_CAST(CONCAT_WS('-'
       , JSON_VALUE(J,'$[5]')
       , JSON_VALUE(J,'$[1]')
       , JSON_VALUE(J,'$[2]')) AS DATE) AS Result
FROM @tbl
CROSS APPLY (VALUES('["' + REPLACE(col,SPACE(1),'","') + '"]')) AS B(J);

Output

ID	col	J	Result
1	Tue Feb 18 00:00:00 CST 2025	["Tue","Feb","18","00:00:00","CST","2025"]	2025-02-18
2	Tue Apr 03 00:00:00 CST 2024	["Tue","Apr","03","00:00:00","CST","2024"]	2024-04-03

本文标签： sql serverConverting quotTue Feb 18 000000 CST 2025quot to DateStack Overflow