'DolphinDB: data of 2038.01.20 cannot be filtered out based on the DATETIME type

When querying data in DolphinDB, the data of 2038.01.20 cannot be filtered out based on the DATETIME type. 2038.01.19 can be filtered.



Solution 1:[1]

The data type overflows. The DATETIME type is represented by a 4-bit integer, and the maximum is 2038.01.19. Using a TIMESTAMP type to avoid such problems.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 jinzhi