Shelley Doll finishes her coverage of SQL data types with an overview of datetime and interval data types. Learn more about the basic syntax of these standard SQL types.

The data type returned has the highest precedence of these two data types (true_value, false_value). The next example shows a conventional scenario for the IIF statement.