Hi folks! Hey, what's the correct date format? Is it:

fromDateTime('2022-02-01', 'YYYY-MM-DD')

or

fromDateTime('2022-02-01', 'yyyy-MM-dd')

? And where can I get a comprehensive list of what each format token means?

You can also see: https://docs.pinot.apache.org/configuration-reference/functions/fromdatetime

Thanks man. But now I'm a bit confused between

yyyy

and

YYYY

, what's the difference between them?

seems the same to me

Oh... I guess

y

then could be a negative year, then