Cast in teradata sql

iceman23

Hello,

Any suggestion in the way I used CAST in TERADATA SQL:

AND CAST (EXCEPTION_EVENT_TS AS TIMESTAMP(0) FORMAT 'MM/DD/YYYY HH:MI:SS') = EXCEPTION_EVENT_TS
AND EXCEPTION_EVENT_TS BETWEEN '06/05/2009 00:00:00' AND '06/06/2009 00:00:00'

My error is Invalid Timestamp.

Thanks in Advance.

I was able to resolve my error..hehehe Thanks!

RedSon

if you resolved it, what was it? Thats pretty selfish posting to a forum with a question but then not posting what the fix was.

iceman23

1. Cast ( exception_event_ts date ) = date -1
2. Exception_event_ts between timestamp '06/05/2009 00:00:00' and timestamp '06/06/2009 00:00:00'

Cast in teradata sql

re: Cast in teradata sql

re: Cast in teradata sql

Similar Misc bytes

/bytes/development

/bytes/it

/bytes/about