Loading

HH:mm:ss to Decimal

HH:mm:ss to Decimal

Pramod M

6y1.4kOracle

I have input data like example need to convert as decimal

Ex : 24:30:02 output as 24.5

Thank you.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ramachandran M6y ago
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);
0
Amit Mohanty6y ago
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);
0