[GENERAL] problem in to_char() function
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
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