jlgray48 Posted April 23, 2007 Share Posted April 23, 2007 I have a table that has price as a field. I need the field formatted with 6 digits before and 2 digits after. How would my table creation look? create table inventory( Itemprice ?, Name Char(20), Primary Key (Name) ); Link to comment https://forums.phpfreaks.com/topic/48374-solved-how-to-format-decimal-input/ Share on other sites More sharing options...
AndyB Posted April 23, 2007 Share Posted April 23, 2007 Float(7,2) Link to comment https://forums.phpfreaks.com/topic/48374-solved-how-to-format-decimal-input/#findComment-236495 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.