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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Discretize data?

Status
Not open for further replies.
SQLnewcommer

SQLnewcommer

Technical User
Oct 7, 2005
15
0
0
US
Hello,
I have a table with lesson times, and client no which I extracted from another table. The lesson times are in terms of minutes. How do I group the lesson groups into hours?
Like 7 - 8 pm, 8 - 9pm etc?
 
Sort by date Sort by votes
Can you post your query, sample data, and expected results? Usually, converting from minutes to hours is simple, just divide by 60. Data types may be causing weird issues with your division, that's why showing your code would be helpful for us to give you better advice.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

coorsman
  • Locked
  • Question
Column Data Type. 2
Replies
9
Views
147
Chris Miller
Chris Miller
peac3
  • Locked
  • Question
fill the gap of hierarchy data
Replies
11
Views
179
Chris Miller
Chris Miller
Andrzejek
  • Locked
  • Question
Data types and sizes
Replies
18
Views
182
gmmastros
gmmastros
gussy81
  • Locked
  • Question
Decimal Datatype with negative value
Replies
5
Views
267
Chris Miller
Chris Miller
marn1997
  • Locked
  • Question
Large data base to back word engineer
Replies
5
Views
66
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top