HOUR
Learn how to use the HOUR date/time function in PlaidCloud Lakehouse. Returns the hour from a datetime - see syntax, examples, and output.
Returns the hour from a datetime.
Analyze Syntax
func.hour(<datetime>)
Analyze Examples
func.hour('2024-06-15 14:30:00')
┌────┐
│ 14 │
└────┘
SQL Syntax
HOUR(<datetime>)
SQL Examples
SELECT HOUR('2024-06-15 14:30:00');
┌────┐
│ 14 │
└────┘