Strong Datetime Type Checking

Administrators use this system setting to specify whether to enforce strict checking for date and time data types and whether to reject queries that contain incompatibilities in date and time data types.

Valid Values

  • On — Enforces strict checking for date and time data types. Default
  • Off — Relaxes strict checking for date and time data types. However, invalid queries or queries with severe date and time incompatibilities may still be still rejected. For example, date and time incompatibilities might be rejected if your relational database uses strict checking for those data types.

Apply Required

Yes.

Change Effective

After a few minutes.

Edition

Professional and Enterprise.

API Key and Values

API Key — StrongDatetimeTypeChecking

API Values —
  • YES
  • NO

Documentation Links