text: create class test_class (bigint_col bigint, datetime_col datetime, datetime_col1 datetime, timestamp_col timestamp);
  insert into test_class(bigint_col, datetime_col, datetime_col1, timestamp_col) values (3600000, DATETIME '2001-01-01 00:00:00.999', DATETIME '2001-01-02 00:00:00.999', TIMESTAMP '01/01/2000 10:30:00');
  insert into test_class(bigint_col, datetime_col, datetime_col1, timestamp_col) values (3600000, DATETIME '2001-01-01 00:00:00.000', DATETIME '2001-01-02 00:00:00.000', TIMESTAMP '01/01/2000 10:30:00');
  
  select * from test_class where datetime_col1 = datetime_col + bigint_col * 24 order by 1,2 ;
  select * from test_class where datetime_col1 - datetime_col = bigint_col * 24 order by 1 desc, 2;
  select datetime_col1 + bigint_col - datetime_col  from test_class;
  
  drop class test_class;