This content has been marked as final.
Show 2 replies
-
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
-
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?