[GENERAL] problem in to_char() function

2006-11-16 Thread deepak pal
hi i want to convert 238.000 to 238.0 value 238.000 i got from database how to use to_char() function...??

Re: [GENERAL] problem in to_char() function

2006-11-16 Thread A. Kretschmer
am Thu, dem 16.11.2006, um 16:05:15 +0530 mailte deepak pal folgendes: hi i want to convert 238.000 to 238.0 value 238.000 i got from database how to use to_char() function...?? Use round() instead. test= select round(238.000::numeric, 1); round --- 238.0 (1 row) Andreas