79087373

Date: 2024-10-14 18:58:00
Score: 0.5
Natty:
Report link

I found a handling. It accepts the following:

@Query(
   value = "SELECT MAX(CONVERT('TIMESTAMP', \"inv-date\") + (\"inv-time\" * 1000)) " +
   "rest of query...",
   nativeQuery = true
)
Optional<Date> findLastPaymentInvoiceDate(Long aAccountId);

So while I don't know why the odbc_convert command doesn't work, this convert command does work.

Reasons:
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (0.5):
Posted by: Jesser