Roads and Highways Time Stamp Query Not Working

Question

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 · Answer

https://docs.microsoft.com/en-us/sql/relational-databases/collations/collation-and-unicode-support?view=sql-server-2017

anayoung · Answer

Thanks for your reply. We use an SQL server.

>

KyleGonterwitz · Answer

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.

JakeSkinner_0-1742741223066.png