JODATIME_FORMAT
Learn how to use the JODATIME_FORMAT date/time function in PlaidCloud Lakehouse. Formats a date or datetime using Joda-Time format patterns.
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 │
└────────────┘