Hi Glenn,
update set_name_1
set comp_dt = TO_DATE('01-jan-2025')
where TRUNC(comp_dt) = '01-jan-99';
The standard date format in your oracle schema is declared as 'dd-mon-yy',
so, if you just fire a select "Select sysdate from Dual" it will give you
the date in this format.
U need to change your cedo as...
update set_name_1
set comp_dt = TO_DATE('01-jan-2025', 'dd-mon-yyyy')
where TRUNC(comp_dt) = To_Date( '01-jan-1999', 'dd-mon-yyyy' );
Cheers,
Pravin.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Pravin Ningoo CAPITA
Education Services Ltd.
Stannard Way
Tel : Off +44 (0)1234 832233 Priory Business Park
Res +44 (0)1234 358114 Cardington
Fax: Off +44 (0)1234 838961 Bedford. MK44 3SG
eMail: <mailto:[EMAIL PROTECTED]> England
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> -----Original Message-----
> From: Glenn Dy [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, July 16, 1999 6:46 PM
> To: [EMAIL PROTECTED]
> Subject: 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]
> [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]
