为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】: 8
【操作系统】:
【CPU】:
【问题描述】*:mysql SELECT
t1.ANY_DOG “anyDog”,
t1.ID AS “id”,
t1.ONLINE_TIME as “onlineTime”,
t1.OFFLINE_TIME as “offLineTime”,
(DATE_FORMAT(t1.ONLINE_TIME, ‘%Y-%m-%d %H:%i:%s’) <= DATE_FORMAT( SYSDATE(), ‘%Y-%m-%d %H:%i:%s’))as “onLineCompareNow”,
(DATE_FORMAT(t1.OFFLINE_TIME, ‘%Y-%m-%d %H:%i:%s’) >= DATE_FORMAT( SYSDATE(), ‘%Y-%m-%d %H:%i:%s’))as “offLineCompareNow”
FROM dg_service t1
提示SQL 错误 [42000]: 第 6 行, 第 106 列[as]附近出现错误:
语法分析出错
怎么改成达梦的呀
SELECT
t1.ANY_DOG “anyDog”,
t1.ID AS “id”,
t1.ONLINE_TIME as “onlineTime”,
t1.OFFLINE_TIME as “offLineTime”,
TO_DATE(t1.ONLINE_TIME,‘yyyy-mm-dd HH24:mi:ss’) as “onLineCompareNow”,
TO_DATE(t1.OFFLINE_TIME,‘yyyy-mm-dd HH24:mi:ss’) as “offLineCompareNow”
FROM dg_service t1
WHERE
TO_DATE(t1.ONLINE_TIME,‘yyyy-mm-dd HH24:mi:ss’) <= SYSDATE()
AND TO_DATE(t1.OFFLINE_TIME,‘yyyy-mm-dd HH24:mi:ss’) >= SYSDATE();
select to_char(sysdate,‘yyyy-mm-dd hh24:mi:ss’)