on 11-24-2018 9:46 AM
Hello Experts,
I have tried to use a ADD_YEAR in the sql hana and the return value is in this format "December 12, 2015 12:00:00 AM". I just require the date in dd.mm.yyyy as return. code is given below. Is there any function for this ?
SELECT
ADD_YEARS( ERDAT,
5 ) ,
ERDAT
FROM "SAPABAP1"."VBAK"
;
One option is to use the TO_NVARCHAR function using the format option.
SELECT TO_NVARCHAR( ADD_YEARS( ERDAT, 5 ), 'DD.MM.YYYY' ),
ERDAT
FROM "SAPABAP1"."VBAK";
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.