Buenos días compañeros, tengo la siguiente consulta para convertir día mes año a año mes día, hora minuto segundo
YYYY/MM/DD HH:MI:SS
SELECT T0."DocNum", T0."DocNum", T0."DocDate",T0."DocTime",
CONCAT(
CONCAT(
TO_DATE( CONCAT(
CAST(
extract(
YEAR FROM (T0."DocDate")
)
AS VARCHAR(10)
),
CONCAT( '/',
CONCAT(
CAST(
extract(
MONTH FROM (T0."DocDate")
)
AS VARCHAR(10)
),
CONCAT('/',
CAST(
extract(
DAY FROM (T0."DocDate")
)
AS VARCHAR(10)
)
)
)
)
)
)
)
, 'YYYY/MM/DD')
, ' '
),
CAST(
CONCAT(
CASE WHEN LENGTH (T0."DocTime")=4 THEN SUBSTRING ( T0."DocTime", 1,2)
WHEN LENGTH (T0."DocTime")=3 THEN SUBSTRING ( T0."DocTime", 1,1)
ELSE T0."DocTime"
END,
CONCAT(
CONCAT( ':',
Pedro Pascal
Se unió el 07/03/2018