Supported implicit and explicit casts

The following tables show the supported implicit and explicit casts. The ✓ character indicates that the system supports casts from the data type in the row to the data type in the specified column.

Table 1. Supported implicit and explicit casts: Part 1 of 4
	Char	Varchar	Nchar	Nvarchar	Boolean	JSON
Char		✓	✓	✓	✓	✓
Varchar	✓		✓	✓	✓	✓
Nchar	✓	✓		✓	✓	✓
Nvarchar	✓	✓	✓		✓	✓
Byteint	✓	✓	✓	✓
Smallint	✓	✓	✓	✓
Integer	✓	✓	✓	✓
Bigint	✓	✓	✓	✓
Numeric	✓	✓	✓	✓
Real	✓	✓	✓	✓
Double	✓	✓	✓	✓
Timestamp	✓	✓	✓	✓
Date	✓	✓	✓	✓
Time	✓	✓	✓	✓
TimeTz	✓	✓	✓	✓
Interval	✓	✓	✓	✓
Boolean				✓
JSON				✓

Table 2. Supported implicit and explicit casts: Part 2 of 4
	Byteint	Smallint	Integer	Bigint
Char	✓	✓	✓	✓
Varchar	✓	✓	✓	✓
Nchar	✓	✓	✓	✓
Nvarchar	✓	✓	✓	✓
Byteint		✓	✓	✓
Smallint	✓		✓	✓
Integer	✓	✓		✓
Bigint	✓	✓	✓
Numeric	✓	✓	✓	✓
Real	✓	✓	✓	✓
Double	✓	✓	✓	✓
Timestamp
Date
Time
TimeTz
Interval
Boolean

Table 3. Supported implicit and explicit casts: Part 3 of 4
	Numeric	Real	Double
Char	✓	✓	✓
Varchar	✓	✓	✓
Nchar	✓	✓	✓
Nvarchar	✓	✓	✓
Byteint	✓	✓	✓
Smallint	✓	✓	✓
Integer	✓	✓	✓
Bigint	✓	✓	✓
Numeric		✓	✓
Real	✓		✓
Double	✓	✓
Timestamp
Date
Time
TimeTz
Interval
Boolean

Table 4. Supported implicit and explicit casts: Part 4 of 4
	Timestamp	Date	Time	TimeTz	Interval
Char	✓	✓	✓	✓	✓
Varchar	✓	✓	✓	✓	✓
Nchar	✓	✓	✓	✓	✓
Nvarchar	✓	✓	✓	✓	✓
Byteint
Smallint
Integer
Bigint
Numeric
Real
Double
Timestamp		✓	✓	✓
Date	✓
Time					✓
Interval			✓
Boolean