MySQL查询还有多少下班

在mysql查询

SELECT SEC_TO_TIME(TIMESTAMPDIFF(SECOND,NOW(),DATE_FORMAT(NOW(),'%Y-%m-%d 18:00:00') )) '离下班还剩';

Oracle 查询

SELECT TO_CHAR(EXTRACT(HOUR FROM NUMTODSINTERVAL((TRUNC(SYSDATE) + 18/24 - SYSDATE)*86400, 'SECOND')),'FM00') || ':' ||
       TO_CHAR(EXTRACT(MINUTE FROM NUMTODSINTERVAL((TRUNC(SYSDATE) + 18/24 - SYSDATE)*86400, 'SECOND')),'FM00') || ':' ||
       TO_CHAR(EXTRACT(SECOND FROM NUMTODSINTERVAL((TRUNC(SYSDATE) + 18/24 - SYSDATE)*86400, 'SECOND')),'FM00') AS "离下班还剩" 
FROM DUAL;

 Pgsql查询

SELECT to_char((date_trunc('day', current_timestamp) + interval '18 hour' - current_timestamp), 'HH24:MI:SS') AS "离下班还剩";

pgsql查询离指定日期还有多少天

		SELECT 
    TO_CHAR(
        AGE(TIMESTAMP '2024-03-08', NOW()), 
        'DD "天" HH24 "小时" MI "分钟" SS "秒" MS "毫秒"'
    ) AS "离3月8号还有多久"