注册

这段SQL在达梦要怎么转呀?求解!

虎虎生威🐯 2023/09/04 543 2

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:WIN 10
【CPU】:
【问题描述】*:
image.png

SELECT COUNT
( 1 )
FROM
(
SELECT
requestType,
requestTypeName,
CONVERT ( VARCHAR ( 255 ), DATEADD( s, CAST ( LEFT ( requestMillis, 10 ) AS INT ), '1970-01-01 08:00:00' ), 20 ) AS requestMillis,
CONVERT ( VARCHAR ( 255 ), DATEADD( s, CAST ( LEFT ( resultMillis, 10 ) AS INT ), '1970-01-01 08:00:00' ), 20 ) AS resultMillis,
CONVERT ( INT, ( resultMillis - requestMillis ) ) AS totalMillis,
CONVERT ( INT, otherMillis ) AS otherMillis,
CONVERT ( INT, ( clientRequestMillis - requestMillis ) ) AS clientBeforeMillis,
CONVERT ( INT, ( clientResultMillis - clientRequestMillis ) ) AS clientMillis,
CONVERT ( INT, ( insertRequestMillis - clientResultMillis ) ) AS clientAfterMillis,
CONVERT ( INT, ( insertResultMillis - insertRequestMillis ) ) AS insertMillis,
CONVERT ( INT, ( resultMillis - insertResultMillis ) ) AS insertAfterMillis,
errorFlag,
trackId,
hisUuId,
submitCount,
version
FROM
auditor_prescr_record
WHERE
1 = 1
) dataVal
WHERE
1 = 1

回答 0
暂无回答
扫一扫
联系客服