How to work with Date format in SQL: Set command

Rasmus Wullf Jensen

Updated June 07, 2017 16:33

The following works:

Code:

SET($[$12.0.DATE]|SQL: SELECT CONVERT(VARCHAR(10), GETDATE(), 120))

So this should also work:

Code:

Set ($[$12.0.DATE]|SQL: SELECT CONVERT(VARCHAR(10), DateAdd(DD,30,GETDATE()),120));

The main reason is that the date has to be in format YYYY-MM-DD

Comments

1 comment

Yaremi Miranda Lopez June 07, 2017 16:33

If you work with HANA, this sintax works working with dates and if you want to add more:

Set($[$BOYX_1.0.DATE]|SQL:SELECT TO_VARCHAR(ADD_DAYS($[$12.0.DATE],30)) FROM DUMMY);

0

Permalink

Please sign in to leave a comment.

Powered by Zendesk