Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Converting full date value to string or vice-versa

Re: Converting full date value to string or vice-versa

From: Anup Dey <anup.deyNOanSPAM_at_cableinet.co.uk.invalid>
Date: 2000/07/30
Message-ID: <04c6bcff.4db9b06b@usw-ex0106-044.remarq.com>#1/1

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

Received on Sun Jul 30 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US