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 Rhinorhino 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
Joined
Jan 30, 2002
Messages
2,963
Location
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 Question
Need to compare two tables and list the differences
Replies
3
Views
1K
EdLentz
EdLentz
Darryl Johnson
  • Locked
  • Question Question
Adding labor hours to a date time field
Replies
5
Views
604
Andrzejek
Andrzejek
Arthur Lewis
  • Locked
  • Question Question
How to effect a NOWAIT in the LOCK TABLES statement?
Replies
0
Views
332
Arthur Lewis
Arthur Lewis
trandrus
  • Locked
  • Question Question
incrementing a column without having to query the db first
Replies
4
Views
508
Chris Miller
Chris Miller
Prochotap
  • Locked
  • Question Question
How to sumarize “sickness time” to the end of order - mysql
Replies
0
Views
241
Prochotap
Prochotap

Part and Inventory Search

Sponsor

Back
Top