Forum Discussion

Thoringer's avatar
Thoringer
New Member
3 years ago
Solved

PBI Oracle Error when trying to get SYSDATE

Hello fellow PBI users, I try to create a subquery to use further down in my code: WITH TODAY AS( SELECT TO_CHAR(SYSDATE, 'MM-DD-YYYY') "NOW" FROM DUAL) So, if you do SELECT * FROM TODAY, y...
Need Help
Tips and Tricks
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi Thoringer 

     

    Please remove the quote around "NOW". 

    SELECT 
    TO_CHAR(SYSDATE, 'MM-DD-YYYY') AS NOW
FROM 
    dual

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

Thoringer's avatar
Thoringer
New Member
3 years ago

Wow! That was simple! I tried all kinds of acrobatics, but the removal of the qutation marks does work! Thank you a lot!