Product Documentation

SQL Operations Guide

Previous Topic

Next Topic

SQL_OPTION BADTIMES_ASNULL

SQL_OPTION BADTIMES_ASNULL

An invalid time is reported as CTDBRET_INVTIME. A configuration option, SQL_OPTION BADTIMES_ASNULL, allows time fields that would normally return an error due to an out-of-range date to be returned vis SQL as NULL.

Warning This option is only recommended when initially analyzing "dirty" data in tables, for example, linked legacy data. Using this option can mask actual invalid data that should be corrected, for example, wrong query result if the affected fields are part of an index.

See Also

SQL_OPTION BADDATES_ASNULL (SQL_OPTION BADDATES_ASNULL, SQL_OPTION BADDATES_ASNULL).

TOCIndex