SQL 53 🛢️ Data Type Conversion with CAST and CONVERT
A value has a type. The type determines what the value can do: a string can be concatenated, a number can be added, a date can be compared to another date. When a value needs to be used in a context where its type is not accepted, it must be converted. SQL provides two functions…