mySQL and trailing 0

[rmatthew]

I need a way to display a value with trailing zeros to two decimal in MySQL?

Any ideas....

 

[wyrd]

Seeing as theres a lack of responses to both of your questions, Im going to assume that this is because no one here really has any real experience with MySQL (which would make sense given that this is a forum based off of a Microsoft technology).

The only real help I can provide is to give you a link;
www.mysql.com

Its the main site for MySQL and provides very thorough online documentation of the language. Hopefully you can find your answer in there by looking up how to deal with numeric values. For your other thread, look up DateTime and see what you an find.

Sorry that I cant offer any more help then that.

 

[sizer]

example

try with this example:

CREATE TABLE `myTable` (`myfield` FLOAT (6,2) ZEROFILL DEFAULT NOT NULL )

also you can put DEFAULT 0.00 or something else!!!