Syntax
TIMESTAMP_TO_SCN(timestamp)
Purpose
TIMESTAMP_TO_SCN() returns the system change number (SCN) corresponding to a timestamp, which is the input argument of this function. The input argument is of the DATETIME type, and the return value is of the UINT64_T type.
Examples
obclient> SELECT TIMESTAMP_TO_SCN("2023-02-21 00:00:01");
+-----------------------------------------+
| timestamp_to_scn("2023-02-21 00:00:01") |
+-----------------------------------------+
| 1676908801000000000 |
+-----------------------------------------+
1 row in set