Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 time format hours and mins not decimal

Author  Topic 

Paul
Starting Member

4 Posts

Posted - 2001-02-27 : 07:55:41

Hi,
I have made a web page using asp and sql db.
The page gets details of minutes stored in one column and on the web page coverts the minutes to hours and fraction of hour: so displays 1.25 hours. I would like to display the hours and mins as 1 hr 15 mins, but don't know how.

Any help would be welcome.

Thank you,

paul
   

- Advertisement -