Skip to Content
0

Can I use NVL with Date in SAP BODS?

Jan 25, 2017 at 08:11 AM

129

avatar image

Hi All,

Below the SQL server Query and i need to Convert SAP BODS ?

SQL Server Query:

Rtrim(Isnull(Convert(Char(10),PatientDOB,101),''))

I Need to write the logic in SAP BODS using Query Transform?

Please let me know if any one..

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

kalyani kolli Apr 07, 2017 at 07:03 AM
0

Hi Kris,

Please try this one..

Rtrim(NVL(Cast(PatientDOB,char(10)),''))

Share
10 |10000 characters needed characters left characters exceeded
Ravi kiran Pagidi Apr 11, 2017 at 06:21 AM
0

Hi Kris,

Please try below

rtrim_blanks(nvl(to_char(PatientDOB,'YYYYMMDD'),''))

Thanks,

Ravi kiran.

Share
10 |10000 characters needed characters left characters exceeded