我最近遇到了这个问题，并找到了最合理的解决方案，可以将任何UNSIGNED整数简单地转换为SIGNED。
SELECt *, ((1 / log(1301980250 - cast(date as signed)) * 175) as weight FROM news_articles ORDER BY weight
我最近遇到了这个问题，并找到了最合理的解决方案，可以将任何UNSIGNED整数简单地转换为SIGNED。
SELECt *, ((1 / log(1301980250 - cast(date as signed)) * 175) as weight FROM news_articles ORDER BY weight
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
