On Thursday, March 14, 2002, at 05:02 AM, Lalita P wrote:
> We found the statement below logged in torque.log file.
> 2002-03-14 15:55:24,360 [HttpProcessor[8000][4]] DEBUG
> org.apache.torque.util.BasePeer - SELECT
> SCARAB_USER_PREFERENCE.USER_ID, SCARAB_USER_PREFERENCE.PASSWORD_EXPIRE
> FROM SCARAB_USER_PREFERENCE WHERE (SCARAB_USER_PREFERE
> NCE.USER_ID=200) AND
> (SCARAB_USER_PREFERENCE.PASSWORD_EXPIRE<TO_DATE('Thu Mar 14 15:55:24
> GMT+05:30 2002', 'yyyy-mm-dd hh24:mi:ss..' ))
TO_DATE('Thu Mar 14 15:55:24 GMT+05:30 2002', 'yyyy-mm-dd hh24:mi:ss..' )
The date value you are supplying ('Thu Mar 14 15:55:24 GMT+05:30 2002')
does not fit the format you are trying to use ('yyyy-mm-dd
hh24:mi:ss..').
It would be hard to find any algorithm that can convert 'Thu' into a four
digit year. 8^)
-Eric
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
