Incorrect date format pattern in `DateGen`

[Marcono1234]

Describe the bug https://github.com/apache/drill/blob/138563a55141b8844c99f5853894b1e63fcf9582/exec/java-exec/src/main/java/org/apache/drill/exec/store/mock/DateGen.java#L47

• m is 'minute in hour'; should probably be M
• D is 'day in year'; should probably be d

To Reproduce

Date date = Date.from(Instant.parse("2024-10-26T22:00:00Z"));
// Bug: Prints "2024-00-301"
new SimpleDateFormat("yyyy-mm-DD").format(date);

Drill version master (138563a55141b8844c99f5853894b1e63fcf9582)

[pjfanning]

yyyy-MM-dd seems more correct alright - do you want to do a PR?

[Marcono1234]

I am not sure if that could break something, in case parts of this project rely on this incorrect format. Or if DateGen is even used at all.

If possible, could you or some of the other maintainers please fix it instead?

(It is not urgent for me though; I am not using the DateGen class, but just stumbled upon this issue in its source code.)