[GitHub] [incubator-doris] cambyzju commented on issue #9587: [Bug] unix_timestamp/from_unixtime timestamp function exception

[GitBox <gi...@apache.org>]

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: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org