1create table t1 (a int); 2insert into t1 values (4),(8); 3select distinct 100 mod timestampadd( week, a, '2002-05-20' ) from t1; 4100 mod timestampadd( week, a, '2002-05-20' ) 5100 6drop table t1; 7create table t1 (i int); 8insert into t1 values (2),(4); 9select distinct convert_tz( '2001-03-21', 'utc', 'met' ) mod i from t1; 10convert_tz( '2001-03-21', 'utc', 'met' ) mod i 110 12drop table t1; 13