Redshift Time Dimension SQL

redshift_dim_time.sql

CREATE VIEW dw.dim_time_vw AS
with nums AS (
SELECT TOP 86400
row_number() over (
PARTITION BY NULL ORDER BY id) AS num
FROM l_browser)

SELECT 
to_char(
DATEADD(second, num-1, cast('2000-01-01' AS date)), 'HH24MISS') AS time_key,
to_char(
DATEADD(second, num-1, cast('2000-01-01' AS date)), 'HH24:MI:SS') AS time,
cast(to_char(
DATEADD(second, num-1, cast('2000-01-01' AS date)), 'HH24') AS int) AS hour,
cast(to_char(
DATEADD(second, num-1, cast('2000-01-01' AS date)), 'MI') AS int) AS minute,
cast(to_char(
DATEADD(second, num-1, cast('2000-01-01' AS date)), 'SS') AS int) AS second

FROM nums;