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

user7638003 Nov 30, 2017 12:51 AM

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

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

Youssef_B_82 Nov 30, 2017 4:49 PM (in response to user7638003)

Hi,

You might want to refer to this thread
TO_DATE(TO_CHAR(sysdate, 'MM/DD/YYYY'), 'MM/DD/YYYY')

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
Like Show 0 Likes(0)

Actions
2. Re: How to Conevrt this Date to MM-DD-YYYY format? DATETIME (1999-02-08-08.16.14.534441)

user7638003 Dec 6, 2017 8:35 PM (in response to Youssef_B_82)

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?
Like Show 0 Likes(0)

Actions

Join the world’s largest interactive community dedicated to Oracle technologies.