Jump to content
We've recently updated our Privacy Statement, available here ×

glezot

Members
  • Posts

    1
  • Joined

  • Last visited

glezot's Achievements

Newbie

Newbie (1/14)

  • Week One Done
  • One Month Later
  • One Year In
  • First Post Rare
  • Conversation Starter Rare

Recent Badges

0

Reputation

  1. Hello, i have this error ORA-01843: not a valid month, at the next query but on Sqldeveloper works perfectly, anyone knows how solve it: AND (0=to_number($P{ejecuccion}) OR (( to_timestamp(cnt.CNT_DTIING) BETWEEN to_timestamp($P{fechaInicio}) AND to_timestamp($P{fechaFin}) or nvl(to_timestamp(cnt.CNT_DTIFIN),to_timestamp('01/01/9999','DD/MM/YYYY')) BETWEEN to_timestamp($P{fechaInicio}) AND to_timestamp($P{fechaFin}) or (to_timestamp(cnt.CNT_DTIING) < to_timestamp($P{fechaInicio}) and to_timestamp($P{fechaFin})< nvl(to_timestamp(cnt.CNT_DTIFIN),to_timestamp('01/01/9999','DD/MM/YYYY'))))))
×
×
  • Create New...