TO_DATE with no format hint, but it has

[WexSoft]

Hi Folks

The hint "TO_DATE without format in " is being generated on compile of a package body, but the TO_DATE does have a format - here is the line causing the hint:

v_date := to_date(((in_year*100) + v_period_index),'YYYYMM');

Why is this generating the hint? The format 'YYYYMM' is there.

If you need any more details, let me know.

Best regards

Billy

 

[Marco Kalter]

This seems like a bug. We'll fix it.

The only workaround is to remove the parentheses for the date expression if possible.