Need help with Time Difference Please

[linuxjr]

I'm using Sybase Adaptive Server Anywhere. I want to be able to find the time difference in decimal format. The example would be:

hours_start hours_end
-----------------------------
4:00 AM 5:15 AM

I have tried this sql statement:

select datediff(minutes, hours_end, hours_start)

I get 75 minutes which is correct but I want to get 1.25 (75/60) so I try this:

select datediff(minutes, hours_end, hours_start)/60

but I get a one. Any help or tips be greatly appreciated. Have a nice day.

I know the

 

[tlbroadbent]

linuxjr, try this.

Select datediff(minutes, hours_end, hours_start)/60.0

By the way, which database are you using. You shouuld post your questions for specific databases in the appropriate forums. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.