Home » RDBMS Server » Server Administration » convert minutes to hours and minutes
convert minutes to hours and minutes [message #374939] Thu, 12 July 2001 07:39 Go to next message
serdar
Messages: 4
Registered: July 2001
Junior Member
I have a number field that shows minutes e.g. 80
I need to convert it to hours and minutes in the following format 01:20

Report message to a moderator

Re: convert minutes to hours and minutes [message #374940 is a reply to message #374939] Thu, 12 July 2001 08:06 Go to previous message
Bala
Messages: 205
Registered: November 1999
Senior Member
HI,
select floor(80/60) || ':' || mod(80,60) as hour_mins from dual;

Report message to a moderator

Previous Topic: format date field
Next Topic: Regarding Joins
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 19:53:46 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.