please provide me the best way to convert a time (1 hour 30 min 48 sec) in hours without decimal.....
I m waiting....
You can use DATEPART to return the hour component of a time value:
SELECT DATEPART(hour, CAST('01:30:48' AS time));
Dan Guzman, SQL Server MVP, http://www.dbdelta.com
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?