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