Ansi SQL type casting
13,166
The CAST
expression was added in SQL-92. You can see it for example in this draft.
Author by
Mikhail.Mamaev
Updated on August 10, 2022Comments
-
Mikhail.Mamaev almost 2 years
Is it allowed to cast types in ANSI SQL like in postgres for example:
SELECT SUM( CAST(qnty AS int) - CAST(reserve AS int) ) AS sum ...
qnty and reserve are character columns.