Re: SQR - ORA-01722

[Ray Ontko <rayo@ONTKO.COM>]

> In general is is better to but in a $Space or $Blank into date or number
> field?
>
> Let $Space = ' '
> Let $Blank = ''
>
> We are placing some blanks and spaces into dates fields that will be filled
> in when a particular process runs.

It would be useful to see the string that is being converted.
The string should only contain a valid date.  It is possible
that extra spaces could foul things up.   You should be able
to test this with a short program that includes this:

   begin-select
   to_char(to_date($my_string,'dd-mon-yy'),'dd-mon-yy') &my_string
   from dual
   end-select
   show &my_string

Or something similar. This example shouuld work with Oracle.

Ray
----------------------------------------------------------------------
Ray Ontko       |  Ray Ontko & Co  |  "Time for a new signature line."
rayo@ontko.com  |  Richmond, In    |  See us at http://www.ontko.com/