> I want format a column in select result: > > 1.1 => 1.10 > > Any idea? Try the to_date() function like SELECT to_char(1.1, '0.99'); Yours, Laurenz Albe ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly