convert/format

  • Thread starter Thread starter Guy Cohen
  • Start date Start date
G

Guy Cohen

Hi all
I have an integer column with currency information in cents.
How do I select x/100 correctly ? currently the result truncates the cents.

"SELECT mycolumn/100 from mytable"


Please advise
Guy
 
Guy said:
Hi all
I have an integer column with currency information in cents.
How do I select x/100 correctly ? currently the result truncates the cents.

"SELECT mycolumn/100 from mytable"


Please advise
Guy
Click to expand...

This is a SQL question in the ASP forum!


SELECT cast(mycolumn/100 as decimal(18,2)) from mytable

Look up "cast" and "datatypes" in Books Online
 
Since sql is an essential part of web programming, it is ok to ask simple
sql questions here. When you need an expert-level advice, you have more
chances of getting it on the special group.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display Numbers as Words 3
Rounding cents 3
Calculation Problem 2
convert figures into words on Microsft Excel 3
Format date 2
Linq Select in 2
How to convert 1223/100 to 12.23 not 12 in sql server? 2
Formatting output fron Helper Function in Template? Syntax? 1

Back
Top