Redshift Error: 1 unrecognized node type: 407
Posted: Thu 13 Feb 2020 14:37
This query works:
SELECT CONVERT_TIMEZONE('America/New_York', sae.event_time) AS local_time, sae.*
FROM stl_alert_event_log sae
WHERE
(sae.event_time > CONVERT_TIMEZONE('America/New_York', 'UTC', (SELECT DATEADD(hrs, 9, TRUNC(GETDATE()))))
AND sae.event_time < CONVERT_TIMEZONE('America/New_York', 'UTC', (DATEADD(hrs, 18, TRUNC(GETDATE())))))
This return an error:
SELECT CONVERT_TIMEZONE('America/New_York', sae.event_time) AS local_time, sae.*
FROM stl_alert_event_log sae
WHERE
(sae.event_time > CONVERT_TIMEZONE('America/New_York', 'UTC', (SELECT DATEADD(hrs, 9, TRUNC(GETDATE()))))
AND sae.event_time < CONVERT_TIMEZONE('America/New_York', 'UTC', (DATEADD(hrs, 18, TRUNC(GETDATE())))))
ORDER BY sae.event_time
SELECT CONVERT_TIMEZONE('America/New_York', sae.event_time) AS local_time, sae.*
FROM stl_alert_event_log sae
WHERE
(sae.event_time > CONVERT_TIMEZONE('America/New_York', 'UTC', (SELECT DATEADD(hrs, 9, TRUNC(GETDATE()))))
AND sae.event_time < CONVERT_TIMEZONE('America/New_York', 'UTC', (DATEADD(hrs, 18, TRUNC(GETDATE())))))
This return an error:
SELECT CONVERT_TIMEZONE('America/New_York', sae.event_time) AS local_time, sae.*
FROM stl_alert_event_log sae
WHERE
(sae.event_time > CONVERT_TIMEZONE('America/New_York', 'UTC', (SELECT DATEADD(hrs, 9, TRUNC(GETDATE()))))
AND sae.event_time < CONVERT_TIMEZONE('America/New_York', 'UTC', (DATEADD(hrs, 18, TRUNC(GETDATE())))))
ORDER BY sae.event_time