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

Question

Summary

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

user7638003 · Answer

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?

Youssef_B_82 · Answer

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