sqlserver,datetime可以转换成float类型,达梦里面怎么改写。
DECLARE @a DATETIME = GETDATE(); SELECT @a, CONVERT(FLOAT,@a) -- 输出 2024-03-13 17:45:53.850 45362.7402065972
SELECT SYSDATE AS aDATETIME, TO_NUMBER(TO_CHAR(SYSDATE, 'J')) + (SYSDATE - TRUNC(SYSDATE)) AS aFLOAT FROM dual;
SELECT
SYSDATE AS aDATETIME,
TO_NUMBER(TO_CHAR(SYSDATE, 'J')) + (SYSDATE - TRUNC(SYSDATE)) AS aFLOAT
FROM dual;