Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to Conevrt this Date to MM-DD-YYYY format? DATETIME (1999-02-08-08.16.14.534441)

Received Response
31
Views
2
Comments
user7638003
user7638003 Rank 2 - Community Beginner
in Oracle Analytics Cloud and Server

Summary

How to Conevrt this Date to MM-DD-YYYY format? DATETIME (1999-02-08-08.16.14.534441)

Content

Please , How to convert this Date ( DATETIME(1999-02-08-08.16.14.534441)  into MM-DD-YYYY format in BI Publisher in data Model? Thanks

Answers

  • Youssef_B_82
    Youssef_B_82 Rank 5 - Community Champion

    Hi,

    You might want to refer to this thread

    Here's an example

    SELECT TO_DATE(TO_CHAR(TO_TIMESTAMP ('1999-02-08-08.16.14.534441', 'YYYY-MM-DD HH24:MI:SS.FF'),'MM-DD-YYYY'),'MM-DD-YYYY') as date1

       FROM DUAL

    Regards,

    Youssef

  • user7638003
    user7638003 Rank 2 - Community Beginner

    Thank you

    because of NLS_date_Format the above sql gives me DD_MON_YYYY, how do I change NLS_DATE_FORMAT locally, through BI Publisher data model, like session variable?