mysql获取时间戳 select unix_timestamp(now()) from dual; sqlserver 获取时间戳 select DATEDIFF(ss,'1970-01-01 08:00:00', GETDATE()) sqlserver 字符拼接 需要字符类型一致,不然拼接会有问题,内容不显示出来 STR(t.id) + STR( DATEDIFF( ss, '1970-01-01 00:00:00', p._28ArchiveTime ) ) AS rowkey