How to add apostrophe as a text in a char of date?

6 次查看（过去 30 天）

Smithy 2022-8-23

评论： Star Strider 2022-8-23

Hello everybody,

I would like to create a character vector.

I tried below code.

DATE = '2019-05-31';

A2 = ['TO_DATE(',DATE,', ''YYYY-MM-DD'') '];

the answer is

A2 =

'TO_DATE(2019-05-31, 'YYYY-MM-DD') '

But I hope to make the answe as below. It has the apostrophe between date as '2019-05-31'.

'TO_DATE('2019-05-31', 'YYYY-MM-DD') '

Is there a way to do it?

Star Strider 2022-8-23

I am not certain what result you want.

Try this —

DATE = '2019-05-31';
A2 = ['TO_DATE(''',DATE,''', ''YYYY-MM-DD'') ']
A2 = 'TO_DATE('2019-05-31', 'YYYY-MM-DD') '

Note the doubled single apostrophes.

Smithy 2022-8-23

Wow... it works well. Thank you very much.

Star Strider 2022-8-23

My pleasure!

MATLAB Environment and Settings Startup and Shutdown

在 Help Center 和 File Exchange 中查找有关 Startup and Shutdown 的更多信息

R2020a

Find the treasures in MATLAB Central and discover how the community can help you!

Translated by