ORA-210000 Oracle error: ORA-01878: specified field not found in datetime or interval | Community
Skip to main content
V
Adobe Employee
vnagarajAdobe Employee
Adobe Employee
April 9, 2018

ORA-210000 Oracle error: ORA-01878: specified field not found in datetime or interval

  • April 9, 2018
  • 1 reply
  • 4485 views

Hi,

I have a query in my workflow and I am using an expression

DateOnly(@START_DATE) greater than or equal to DateOnly(DaysAgo(14)).

When the query runs, for a few records which fall on Daylight saving time shift, is throwing an error.

Tried to use ToDate(@START_DATE) as well, and still the same issue.

Can someone assist on how to get rid of this.

Thanks,

Vignesh

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    1 reply

    florentlb
    florentlb
    Level 10
    April 19, 2018

    Hi Vignesh,

    Can you psot a screenshot of your workflow or the activity throwing the error to check how it's configured?

    Florent

    V
    Adobe Employee
    vnagarajAdobe EmployeeAuthor
    Adobe Employee
    April 19, 2018

    Hi Florent,

    Issue was because of a few records which were present in the database which were in the Daylight saving time difference. Deleted those records and now the workflow runs fine without any issue.

    Thanks,

    Vignesh

      Terms & ConditionsAccessibility statement

      Loading footer...