TIME_FORMAT (Lakehouse v2)

Formats a time value according to a format string.

Analyze Syntax

func.time_format(<time>, <format>)

Analyze Examples

func.time_format('14:30:00', '%H hours %i minutes')

┌───────────────────────┐
│ '14 hours 30 minutes'  │
└───────────────────────┘

SQL Syntax

TIME_FORMAT(<time>, <format>)

SQL Examples

SELECT TIME_FORMAT('14:30:00', '%H hours %i minutes');

┌─────────────────────┐
│ 14 hours 30 minutes  │
└─────────────────────┘