create table # (d datetime) insert # select 123 select *, datediff(day, '1900-01-01', d) diff from # /* d diff ----------------------- ----------- 1900-05-04 00:00:00.000 123 */
22,207
社区成员
121,730
社区内容
加载中
试试用AI创作助手写篇文章吧