Cast in teradata sql

[iceman23]

Hello,

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

AND CAST (EXCEPTION_EVEN T_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'