hi all,
im sorry for a nonPFC question but i know you can help me with this.
update set_name_1
set comp_dt = TO_DATE('01-jan-2025')
where TRUNC(comp_dt) = '01-jan-99';
ERROR at line 2:
ORA-01830: date format picture ends before converting entire input string
if i place in '01-jan-25', there will be no syntax error but what is saved in the
database is Jan
01, 1925.
im using sql plus 3.3.3.0.0 and oracle 7.3
thanks,
glenn
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
