2 Replies Latest reply on Sep 18, 2018 3:13 AM by kumar raman

    STR() - need more clarity please help

    kumar raman

      Hi All,


      I connect to a excel datasource.

      1. Created a calculated field


      2. when I drag the calculated field to the rows shelf I get the value as below

      2018-08-18 00:00:00

      Now I connect to a oracle database and did the same steps but the output is different

      Aug 18 2018 00:00:00


      Why the output differs and I need the output to be in 2018-08-18 00:00:00 format irrespective of the datasource I connect to.