ToDateTime

T-SQL |

1.1 KB

None

0 👍

0 👎

Raw Download Clone Embed Print View

-- =======================================================================
-- 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

Comments

01/01/70 12:00:00 AM UTC
Plain Text |
0 B
|
👍
/
👎
01/01/70 12:00:00 AM UTC
Plain Text |
0 B
|
👍
/
👎

Pasted

ToDateTime

Comments