JODATIME_FORMAT (Lakehouse v2)

Formats a date or datetime using Joda-Time format patterns.

Analyze Syntax

func.jodatime_format(<datetime>, <pattern>)

Analyze Examples

func.jodatime_format('2024-06-15', 'yyyy/MM/dd')

┌──────────────┐
│ '2024/06/15'  │
└──────────────┘

SQL Syntax

JODATIME_FORMAT(<datetime>, <pattern>)

SQL Examples

SELECT JODATIME_FORMAT('2024-06-15', 'yyyy/MM/dd');

┌────────────┐
│ 2024/06/15  │
└────────────┘