Selecting development language as SQL doesn't format the message properly

Question

Selecting development language as SQL doesn't format the message properly

Naomi Nosonovsky 8,906

Hi everybody,

When I was answering this question https://learn.microsoft.com/en-us/answers/questions/1313782/how-to-get-a-date-from-a-text?orderby=helpful I selected SQL as a development language but the code is not formatted nicely. I even tried to edit the message a few times, I can see it formatted when I am in edit mode, but when the message is saved the formatting is gone.

What do I need to do to have the code formatted correctly?

Thanks in advance.

Viorel 127K

Do you mean this kind of formatting?

/* Sample data begin*/
DECLARE @t TABLE (id INT IDENTITY PRIMARY KEY, info VARCHAR(200))

INSERT INTO @t (info)
VALUES ('Sep 14, 2023 - Huskey Harvest'), ('July 20, 2023 - Retirement'), ('July 25, 2023 - Entertainment')
/* Sample data end */

Naomi Nosonovsky 8,906 Reputation points

2023-06-20T15:47:03.42+00:00

Yes, what did you do to format correctly?
Naomi Nosonovsky 8,906 Reputation points

2023-06-20T15:52:07.28+00:00

I tried a couple of more times and finally got it saved with proper formatting