468,550 Members | 2,435 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,550 developers. It's quick & easy.

Cast in teradata sql

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!
Sep 1 '09 #1
2 7538
RedSon
5,000 Expert 4TB
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.
Sep 1 '09 #2
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'
Oct 9 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Paul Watson | last post: by
reply views Thread by mgnmsoft | last post: by
1 post views Thread by Michael L. | last post: by
12 posts views Thread by jdokos | last post: by
1 post views Thread by terrordata | last post: by
reply views Thread by NPC403 | last post: by
1 post views Thread by UniDue | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.