Check out the time component of the date, using to_char(NC_DATE_CLS,
'DD-MON-RR HH24:MI:SS')
Regards
Naveen
Please see the official ORACLE-L FAQ: http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--