Welcome to the Lounge

Quote:

And that ends up entirely as heat and cat videos we must get rid of

public static class ExtendTimeSpan
{
    public static TimeSpan ParseFromFormattedInt(int value)
    {
        return new TimeSpan(0).ParseFromFormattedInt(value);
    }

    public static TimeSpan ParseFromFormattedInt(this TimeSpan span, int value)
    {
        TimeSpan result = new TimeSpan(0);
        string timeString = value.ToString();
        string padding    = new String('0', 6 - timeString.Length); 
        timeString = ((timeString.Length < 6) ? string.Concat(padding, timeString) : timeString).Insert(4, ":").Insert(2,":");
        try
        {
            result     = TimeSpan.ParseExact(timeString, "g", CultureInfo.CurrentCulture);
        }
        catch (Exception)
        {
        }
        return result;
    }
}

public static class ExtendTimeSpan
{
    public static TimeSpan ParseFromFormattedInt(int value)
    {
        int hours = Math.DivRem(value, 10000, out value);
        int minutes = Math.DivRem(value, 100, out value);
        int seconds = value + minutes * 60 + hours * 3600;
        return TimeSpan.FromSeconds(seconds);
    }
 
    public static TimeSpan ParseFromFormattedInt(this TimeSpan span, int value)
    {
        return ParseFromFormattedInt(value);
    }
}

SELECT 
    TIMEFROMPARTS(active_end_time / 10000, (active_end_time / 100) % 100, active_end_time % 100, 0, 0)
FROM
    msdb.dbo.sysschedules
;

Richard Deeming wrote:

Or, in SQL (2012 or later):

int year = Math.DivRem(value, 10000, out value);
int month = Math.DivRem(value, 100, out value);
int day = value;
return new DateTime(year, month, day);

TimeSpan span = TimeSpan.FromSeconds(1);