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

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?

Answer 1

[Star Strider]

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]

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

[Star Strider]

My pleasure!