ToDateTime

-- =======================================================================
-- Author:      Goose
-- Create date: 2021-02-26
-- Description: Convierte una cadena con formato 'yyyyMMddhhmmss' en fecha
-- =======================================================================
CREATE FUNCTION [dbo].[ToDateTime]
(
    @valor VARCHAR(14)
)
RETURNS DateTime
AS
BEGIN
    DECLARE @Result DateTime
    DECLARE @year int, @month int, @day int, @hour int, @minute int, @second int, @valorEntero numeric

    SELECT @valorEntero = CAST(@valor as numeric)
    SELECT @year = FLOOR(@valorEntero / 10000000000)
    SELECT @valorEntero -= @year * 10000000000
    SELECT @month = FLOOR(@valorEntero / 100000000)
    SELECT @valorEntero -= @month * 100000000
    SELECT @day = FLOOR(@valorEntero / 1000000)
    SELECT @valorEntero -= @day * 1000000
    SELECT @hour = FLOOR(@valorEntero / 10000)
    SELECT @valorEntero -= @hour * 10000
    SELECT @minute = FLOOR(@valorEntero / 100)
    SELECT @valorEntero -= @minute * 100
    SELECT @second = @valorEntero

    SELECT @Result = DATETIMEFROMPARTS(@year, @month, @day, @hour, @minute, @second, 0)

    RETURN @Result
END