Menu
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.
567
CAST is an ANSI Standard and is supported on SQL Server, MySQL, ORACLE, and others. CAST limits formatting to enable data conversions. CONVERT on the other hand, can be used for formatting date/time, and money data types. CAST has a simple syntax.
The ANSI SQL standards specify qualifiers and formats for character representations of DATETIME and INTERVAL values. The standard qualifier for a DATETIME value is YEAR TO SECOND, and the standard format is as follows: YYYY-MM-DD HH:MM:SS.
You can cast to many SQL Server types such as binary , char , varchar , date , datetime , time , decimal , bigint , and float .
SQL Server CAST() Function The CAST() function converts a value (of any type) into a specified datatype. Tip: Also look at the CONVERT() function.
The CAST expression was added in SQL-92. You can see it for example in this draft.
187
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
