Incorrect date format pattern in DateGen

[Marcono1234]

Describe the bug

drill/exec/java-exec/src/main/java/org/apache/drill/exec/store/mock/DateGen.java

Line 47 in 138563a

fmt = new SimpleDateFormat("yyyy-mm-DD");

• 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 (138563a)

[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.)