blob: f6de436abfe4e2ae92a70c7777c63c68d3fe5847 [file] [log] [blame]
SELECT
TIMESTAMPDIFF(SQL_TSI_HOUR, CAST(TIMESTAMPADD(SQL_TSI_SECOND, 7200, CAST(o_orderdate AS TIMESTAMP)) AS TIMESTAMP), CAST(o_orderdate AS TIMESTAMP)) AS num_of_hours
FROM
orders
WHERE
o_orderkey = 3;