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'