Re: [sqr-users] SQR error

["Prasanna Menta" <pmenta@umuc.edu>]

Try something like this
SELECT (TO_CHAR(SYSDATE,'DD-MON-YY/HH24:MI:SS')) FROM DUAL;
Prasanna

"Vallabhu, Bindu" wrote:
> 
> do you mean to say something like
> 
> begin-select
> 
> edit(columnname, 9999.99)
> 
> from
> 
> tablename
> 
> end-select
> 
> or
> 
> begin-select
> 
> columnname      edit 9999.99
> 
> from
> 
> tablename
> 
> end-select
> 
> -----Original Message-----
> From: Prasanna Menta [mailto:pmenta@umuc.edu]
> Sent: 05/23/2003 4:00 PM
> To: sqr-users@sqrug.org
> Subject: Re: [sqr-users] SQR error
> 
> If oracle database can you use the edit function to select the column?
> PRasanna
> 
> "Vallabhu, Bindu" wrote:
> >
> > Hi Guys,
> > I have understood what the problem is but i dont know how to solve it -
> > Please take a look and let me know if you have any ideas.
> >
> > The error that i get when i try to create a temp table and try to insert
> > values into it is as follows:
> >
> > start time = 2003-05-23-15.37.45.070000
> > An error in the SQL statement creating the temp table temp_resp_v
> > The status = -413.000000
> > The error is = SQL0413N  Overflow occurred during numeric data type
> > conversion.
> >
> > SQLSTATE=22003
> >
> > sql status = -413.000000
> > num of rows inserted into session.temp_resp_v = 0.000000
> > end time = 2003-05-23-15.37.46.160000
> >
> > SQR: End of Run.
> >
> > I get this error because one of the fields has a value which has about 6
> > digits after the decimal point and so an overflow occurs. Is it possible
> to
> > select a value from a database table limiting the number of digits after
> the
> > decimal point.
> >
> > eg: the value in the database is '123456.123456' and i need to read
> > '123456.12' - is this possible somehow using an edit mask or something.
> Any
> > advise would be appreciated.
> > Thank you,
> > Bindu
> >
> > _______________________________________________
> > sqr-users mailing list
> > sqr-users@sqrug.org
> > http://www.sqrug.org/mailman/listinfo/sqr-users
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users