obclient(root@sys)[oceanbase]> select scn_to_timestamp(1754917320484931001);
±--------------------------------------+
| scn_to_timestamp(1754917320484931001) |
±--------------------------------------+
| 2025-08-11 21:02:00.484931 |
±--------------------------------------+
1 row in set (0.001 sec)
obclient(root@sys)[oceanbase]> select timestamp_to_scn(‘2025-08-11 21:02:00.484931’);
±-----------------------------------------------+
| timestamp_to_scn(‘2025-08-11 21:02:00.484931’) |
±-----------------------------------------------+
| 1754917320484931000 |
±-----------------------------------------------+
我在使用scn_to_timestamp和timestamp_to_scn函数进行相互转化时,时间转成scn后会少1,是什么原因呢?是就这样设计的吗?用途是什么呢?