Hi Glenn,
Try this :
update set_name_1
set comp_dt = TO_DATE('01-jan-2025', 'DD-MMM-YYYY')
where TRUNC(comp_dt) = '01-jan-99';
Fabrice LEGRAND
Transiciel Ingenierie
Glenn Dy <[EMAIL PROTECTED]> sur 16/07/99 19:46:06
Pour : [EMAIL PROTECTED]
cc : (ccc : Fabrice LEGRAND/Industrie1/I&S/Ing�nierie/Transiciel)
Objet : PFCSIG simple oracle update
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]
