All Forums Database
TeradataNewB 7 posts Joined 08/14
06 Aug 2014
Sybase to Terdata

We are moving tables from syabse to terdata.I'm a newbie to teradata sytax.
What is the equivalent in teradata to the following?
case when mx_as_of_dt0 > &as_of_dt then cast(&as_of_dt as date) else mx_as_of_dt0 end as mx_as_of_dt?

dnoeth 4628 posts Joined 11/04
06 Aug 2014

Unless the ampersand has a special meaning it's exactly the same in Teradats, simply remove the ampersand or replace it with a valid character, e.g.

case when mx_as_of_dt0 > #as_of_dt then cast(#as_of_dt as date) else mx_as_of_dt0 end as mx_as_of_dt

 

Dieter

You must sign in to leave a comment.