Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Always the easy things take time - currency 1

Status
Not open for further replies.
ZOR

ZOR

Technical User
Jan 30, 2002
2,963
GB
I have tried Decimal, Double as a field type however 6.50 still gets presented as 7. Wish my salary was worked out on MySql, whats the secret, thanks
 
Sort by date Sort by votes
Do you mean it gets stored as 7, or displayed as 7? Can you show us the field's definition, the insert query, and the select query?
 
Upvote 0 Downvote
Many thanks both of you comming back, not watching the football???

r937, thanks you hit it on the head, thanks again. Have a star. Regards
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

EdLentz
  • Locked
  • Question
Need to compare two tables and list the differences
Replies
3
Views
384
EdLentz
EdLentz
Darryl Johnson
  • Locked
  • Question
Adding labor hours to a date time field
Replies
5
Views
193
Andrzejek
Andrzejek
Arthur Lewis
  • Locked
  • Question
How to effect a NOWAIT in the LOCK TABLES statement?
Replies
0
Views
122
Arthur Lewis
Arthur Lewis
trandrus
  • Locked
  • Question
incrementing a column without having to query the db first
Replies
4
Views
170
Chris Miller
Chris Miller
Prochotap
  • Locked
  • Question
How to sumarize “sickness time” to the end of order - mysql
Replies
0
Views
84
Prochotap
Prochotap

Part and Inventory Search

Sponsor

Back
Top