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_at_usw-ex0106-044.remarq.com>#1/1
Date: 2000/07/30
Message-ID: <04c6bcff.4db9b06b_at_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
- Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!