Skip to Content

Can I use NVL with Date in SAP BODS?

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..

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 07, 2017 at 07:03 AM

    Hi Kris,

    Please try this one..

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

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 11, 2017 at 06:21 AM

    Hi Kris,

    Please try below

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

    Thanks,

    Ravi kiran.

    Add comment
    10|10000 characters needed characters exceeded