USE tpch1;
select cast(cdatetime as signed) from datatypetestm;
cast(cdatetime as signed)
19970101000000
19970101000001
19970102000001
19970103000002
19970104000003
20091231235956
20091231235957
20091231235958
20091231235959
20091231235959
20091231235959
select (cdatetime << 8) from datatypetestm;
(cdatetime << 8)
5112345856000000
5112345856000256
5112346112000256
5112346368000512
5112346624000768
5143355196404736
5143355196404992
5143355196405248
5143355196405504
5143355196405504
5143355196405504
select (cdatetime & 0xff0000000000) from datatypetestm;
(cdatetime & 0xff0000000000)
19791209299968
19791209299968
19791209299968
19791209299968
19791209299968
19791209299968
19791209299968
19791209299968
19791209299968
19791209299968
19791209299968
select (cdatetime >> 12) from datatypetestm;
(cdatetime >> 12)
4875512939
4875512939
4875513183
4875513427
4875513671
4905085750
4905085750
4905085750
4905085750
4905085750
4905085750
select (cdatetime | 0xffffff) from datatypetestm;
(cdatetime | 0xffffff)
19970104754175
19970104754175
19970104754175
19970104754175
19970104754175
20091236253695
20091236253695
20091236253695
20091236253695
20091236253695
20091236253695
select (cdatetime ^ 337) from datatypetestm;
(cdatetime ^ 337)
19970100999697
19970100999696
19970101999824
19970102999699
19970104000338
20091231235621
20091231235620
20091231235623
20091231235622
20091231235622
20091231235622
select bit_count(cdatetime) from datatypetestm;
bit_count(cdatetime)
20
21
22
22
22
25
26
26
27
27
27