HOURS_ADD
Learn how to use the HOURS_ADD date/time function in PlaidCloud Lakehouse. Adds a specified number of hours to a datetime - with syntax and examples.
Adds a specified number of hours to a datetime.
Analyze Syntax
func.hours_add(<datetime>, <n>)
Analyze Examples
func.hours_add('2024-01-01 10:00:00', 5)
┌───────────────────────┐
│ '2024-01-01 15:00:00' │
└───────────────────────┘
SQL Syntax
HOURS_ADD(<datetime>, <n>)
SQL Examples
SELECT HOURS_ADD('2024-01-01 10:00:00', 5);
┌─────────────────────┐
│ 2024-01-01 15:00:00 │
└─────────────────────┘