Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle error message

Oracle error message

From: Allen Legg <alegg_at_nortelnetworks.com>
Date: Wed, 14 Nov 2001 17:04:30 GMT
Message-ID: <3bf2a247.1130419817@news.europe.nortel.com> 





Hi,



I am trying to format the value of a DATE datatype field.
My code is



to_date(Schema.Table.Field,'YYYY')



This is the error I receive.


ORA-01830: date format picture ends before converting entire input
string :-1830



The typical format of values in that field is:
2001/7/4 13:25:51



Any ideas on what the problem might be?


Thanks,



Allen
Received on Wed Nov 14 2001 - 11:04:30 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US