asked
I have to write this date to handle my query
Date = Dec.24,2015 For example if substring(price_dt,1,3)='Dec' then 12+'-'+substring(price_dt,5,6 How to write this in an expression like above my expression.
You have some good answers below. This web site runs by you voting and marking the best answers. For each helpful answer below, indicate this by clicking on the thumbs up symbol next to those answers. If any one answer lead to a solution, indicate this by clicking on the check mark next to that answer. This helps indicate your solution for anyone else with the same question.
very similar to this question: [
https://ask.sqlservercentral.com/questions/92630/need-to-get-date-and-time-in-format-of-20120817133.html][1] Here is what you can do (you will have to finish of the CASE, I couldn't be bothered, sorry): DECLARE @TEST AS CHAR(11) SET @TEST = 'Dec.24,2015' SELECT @TEST SELECT RIGHT(@TEST, 4) , SUBSTRING(@TEST, 5, 2) , CASE WHEN LEFT(@TEST, 3) = 'JAN' THEN 1 WHEN LEFT(@TEST, 3) = 'FEB' THEN 2 ..... WHEN LEFT(@TEST, 3) = 'DEC' THEN 12 END, CONVERT(DATE, RIGHT(@TEST, 4) + CASE WHEN LEFT(@TEST, 3) = 'JAN' THEN '1' WHEN LEFT(@TEST, 3) = 'FEB' THEN '2' .... WHEN LEFT(@TEST, 3) = 'DEC' THEN '12' END + SUBSTRING(@TEST, 5, 2)) [1]:
https://ask.sqlservercentral.com/questions/92630/need-to-get-date-and-time-in-format-of-20120817133.html
20 People are following this question.
