Impromptu functions to cognos Expressions

If you are migrating or moving reports from IBMs Impromptu to cognos latest version you might need to be aware of the equivalent expressions in cognos for various functions in Cognos. To make this thing easier, i have attached a list of various functions and their corresponding equivalents.

Impromptu Function to Cognos Expression

ascii ascii ( param1 )
cast_char cast_char ( parameters )
cast_date cast ( param1 , date )
cast_decimal cast_decimal ( parameters )
cast_double cast_double_precision ( param1 )
cast_float cast_float ( param1 )
cast_integer cast_integer ( param1 )
cast_smallint cast_smallint ( param1 )
cast_timestamp cast_timestamp ( param1 )
cast_varchar cast_varchar ( param1 , param2 )

char chr ( param1 )
char2 cast_char ( param1 , param2 )
char_db2 CHAR ( param1 )
char_length length ( param1 )
cinteger cast_integer ( param1 )
coalesce coalesce ( parameters )
d2_decimal DECIMAL ( param1 , param2 , param3 )
date d2_date ( param1 )
date-to-datetime timestamp_iso ( param1 )
date-to-string char ( param1 )
datetime-to-date cast ( param1 , date )
day-of-ymd-interval extract ( day , cast ( param1 , date ) )
days days ( param1 )
decimal d2_decimal ( param1 , param2 , param3 , param4 )
digits digits ( param1 )
double d2_double ( param1 )
event_mon_state event_mon_state ( param1 )
float d2_float ( param1 )
hex hex ( param1 )
insert d2_insert ( param1 , param2 , param3 , param4 )
integer d2_integer ( param1 )
integer-divide floor ( param1 / param2 )
julian_day julian_day ( param1 )
lcase lcase ( param1 )
left left ( param1 , param2 )
length length ( param1 )
ln ln ( param1 )
locate locate ( param1 , param2 , param3 )
long_varchar long_varchar ( param1 )
microsecond microsecond ( param1 )
midnight_seconds midnight_seconds ( param1 )
month-of-ymd-interval extract ( month , cast ( param1 , date ) )
monthname monthname ( param1 )
nodenumber nodenumber ( param1 )
nullif nullif ( param1 , param2 )
number-to-datetime _make_timestamp ( extract ( year , cast ( param1 , date ) ) , extract (month , cast ( param1 , date ) ) , extract ( day , cast ( param1 , date ) ))
number-to-string-real cast_char ( cast_integer ( param1 ) )
octet_length length ( param1 )
position locate ( param1 , param2 )
rand rand ( param1 )
repeat repeat ( param1 , param2 )
right right ( param1 , param2 )
round-down truncate ( parameters )
smallint smallint ( param1 )
sqrt sqrt ( param1 )
string-to-number d2_double ( param1 )
strip strip ( parameters )
table_name table_name ( parameters )
table_schema table_schema ( parameters )
time d2_time ( param1 )
timestamp d2_timestamp ( param1 , param2 )
timestamp_iso timestamp_iso ( param1 )
timestampdiff timestampdiff ( param1 , param2 )
translate1 translate ( param1 )
translate3 translate ( param1 , param2 , param3 )
translate4 translate ( param1 , param2 , param3 , param4 )
trim-leading ltrim ( param1 )
trim-trailing rtrim ( param1 )
truncate d2_truncate ( param1 , param2 )
ucase ucase ( param1 )
upshift upper ( param1 )
value value ( parameters )
varchar d2_varchar ( parameters )
varchar_AS400 d2400_varchar ( parameters )
year-of-ymd-interval extract ( year , cast ( param1 , date ) )