Sign in
apache
/
drill-test-framework
/
9a5d7ecf7f32f0e95c0ea874e75d785fdee9e51d
/
.
/
framework
/
resources
/
Functional
/
timestamp_functions
/
timestampadd_diff_second_hour.sql
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
;