cambyzju commented on issue #9587: URL: https://github.com/apache/incubator-doris/issues/9587#issuecomment-1127613907
For Mysql: https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_unix-timestamp Prior to MySQL 8.0.28, the valid range of argument values is the same as for the [TIMESTAMP](https://dev.mysql.com/doc/refman/8.0/en/datetime.html) data type: '1970-01-01 00:00:01.000000' UTC to '2038-01-19 03:14:07.999999' UTC. This is also the case in MySQL 8.0.28 and later for 32-bit platforms. For MySQL 8.0.28 and later running on 64-bit platforms, the valid range of argument values for UNIX_TIMESTAMP() is '1970-01-01 00:00:01.000000' UTC to '3001-01-19 03:14:07.999999' UTC (corresponding to 32536771199.999999 seconds). Now Doris `unix_timestamp` and `from_unixtime` both are 32-bit, they will overflow in around '2038-01-20'. So we need to update them to 64-bit, if nobody is working on this issue, you could assign it to me. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
