HH:mm:ss to Decimal

Question

I have input data like example need to convert as decimal Ex : 24:30:02 output as 24.5 Thank you.

Amit Mohanty · Answer

In Oracle: CREATE OR REPLACE FUNCTION GETDECMAL(p_STROTHRS NVARCHAR2(8)) RETURN binary_double AS v_RESULT binary_double; v_hms nvarchar2(8); BEGIN v_hms := p_STROTHRS; v_hours number(10); v_minutes number(18,0); v_hours := to_number(to_char(v_hms, 'hour' )); v_minutes := to_number(to_char(v_hms, 'minute' )); v_RESULT := convert ( float ,( v_minutes/60+v_hours)) from dual; RETURN v_RESULT; END ; v_hms VARCHAR2(8); v_hms := '14:30:00' ; SELECT dbo.GETDECMAL( v_hms) FROM dual; In Sql Server: CREATE FUNCTION GETDECMAL(@STROTHRS NVARCHAR(8)) RETURNS float AS BEGIN DECLARE @RESULT float declare @hms nvarchar(8) set @hms = @STROTHRS declare @hours int declare @minutes decimal set @hours = datepart( hour , @hms) set @minutes = datepart( minute , @hms) select @RESULT = convert ( float ,( @minutes/60+@hours)) RETURN @RESULT END DECLARE @hms VARCHAR (8); SET @hms = '14:30:00' ; SELECT dbo.GETDECMAL( @hms);

Ramachandran M · Answer

Try This string HoursWorkedThisWeek = DateTime.Now.ToString("HH:mm:ss"); string[] a = HoursWorkedThisWeek.Split(new string[] { ":" }, StringSplitOptions.None); //a[0] contains the hours, a[1] contains the minutes decimal decHours = Math.Round(Convert.ToDecimal(a[0]) + (Convert.ToDecimal(a[1]) / 60), 2);