Is there a way to type cast in sql plus? Basically I'm using a program that uses sql plus to query a database. When taking the average of speeds it returns a double. The thing is it's not necessary for it to, and I'd prefer it to return and int or something smaller. I tried to use the round() and ceil() functions, but it doesn't really have any affect on what the type is.
Here's an example of my query, I dumbed it down, so it's pretty much nothing now.
Here's an example of my query, I dumbed it down, so it's pretty much nothing now.
| Code: |
| select time, avg(speed)
from stations group by time; |
