Roads and Highways Time Stamp Query Not Working

[anayoung]

Hello,

The below time stamp query that is pulled in with a R & H event or network feature class doesn't always work:

(FromDate is null or FromDate<=CURRENT_TIMESTAMP) and (ToDate is null or ToDate>CURRENT_TIMESTAMP)

We often have to replace it with ToDate is NULL - which doesn't always work either.

We are working on 10.4.1 with Patch 1. Does anyone have an idea what is happening?

Thanks,

Ana

[KyleGonterwitz]

What's your RDBMS- SQL Server, Oracle, Other?  I think Oracle can be configured with case sensitivity, and you can change the configuration to allow case insensitivity.  Could also be related to the encoding.

[anayoung]

Thanks for your reply. We use an SQL server.

>

[KyleGonterwitz]

https://docs.microsoft.com/en-us/sql/relational-databases/collations/collation-and-unicode-support?v...