Hi,

You can do this simpler by using trunc.

But i ask why do you need this format in resultset? Formatting numbers is a client side task, same as for DATE.

Regards,