blob: 9e25393c6e06c1b773cdc8c5ff2b2991539af81c [file] [log] [blame]
SELECT
TIMESTAMPDIFF(SQL_TSI_HOUR, CAST(TIMESTAMPADD(SQL_TSI_MINUTE, -600, CAST(o_orderdate AS TIMESTAMP)) AS TIMESTAMP), CAST(o_orderdate AS TIMESTAMP)) AS num_of_hours
FROM
orders
WHERE
o_orderkey = 3;