TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
pradeep kumar
NA
94
67.1k
Hours Calculation in SQL Server
Feb 22 2014 12:30 PM
I'm doing like this..!!!
DECLARE @minutes AS INT
SET @minutes = 1.80*100
SELECT @minutes / 60 + (@minutes % 60) / 100.0 AS Hours
it gives me 3.000 but the result should be 2.20 hrs
how can i acheive that..?
pls help me out
Reply
Answers (
2
)
self joining
Microsoft SQL Management Studio Package failed to load