Getting exponential format while passing value
Author: lalitpct@gmail.com (lalitpct)
when storing in a form ,value of column tst_local shows -0.000006 but while passing to database it becomes -06.000000 (as shwon below)
tst_total is -0.000006
(_write) WRIT:41 write d
I/O function: U, mode: 0, on file/table: KLM_KEADERS length: 114
if (@@trancount = 0) begin transaction
update klm_headers
set user_ref = 'ref', data_type = 'gh',
g_sdt_ct = 46, most = 101,
reason = 36, nmreason = 301,
abc = 'TEST DECIMAL ROUNDING', bac = 'N',
gover = null, tst_total = -06.000000
database is sybase
interface for tst_total C32.2
syntax tst_total NED,NPR
Layout tst_total NIN,DIS(-zzz,zzz,zzz,zzz,zz9Pzzz)
How I can get exponential format while passing to database ???
This page has no comments.