Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Converting full date value to string or vice-versa
Try altering the session date format using
ALTER SESSION SET NLS_DATE_FORMAT='DD-MON-YYYY HH:MI:SS AM' This will help you with the conversion from String to Date using the same parameters as before.
Reg the ORA-01898 Error, Sysdate is of DATE datatype and hence you cannot re-convert a date to a date which is the cause of the error. The NLS_SESSION_FORMAT should take care of this problem for you.
Hope it helps
![]() |
![]() |