| 1. | CAST(expression AS data type(<length>)) | | |
| 2. | CAST (original_expression AS desired_datatype) | | |
| 3. | CAST(2.78128 AS integer) | | |
| 4. | CAST(2.78128 AS money) | | |
| 5. | CAST('11/11/72' as smalldatetime) AS '11/11/72' | | |
| 6. | select CAST('2002-09-30 11:35:00' AS smalldatetime) + 1 (plus) | | |
| 7. | select CAST('2002-09-30 11:35:00' AS smalldatetime) - 1 (minus) | | |
| 8. | select CAST(CAST('2002-09-30' AS datetime) - CAST('2001-12-01' AS datetime) AS int) | | |
| 9. | The CAST() function accepts one argument, an expression | | |
|
| 10. | Mixing Datatypes: CAST and CONVERT | | |
| 11. | Cast date type to char | | |
| 12. | CAST can still do date conversion | | |
| 13. | Cast date to different format | | |
| 14. | Cast number to varchar and use the regular expressions | | |
| 15. | Conversion with CONVERT function for computated value with numbers in list | | |
| 16. | Cast int to decimal | | |
| 17. | Convert varchar to number | | |
| 18. | CONVERT() does the same thing as the CAST() function | | |
| 19. | CAST(ID AS VarChar(5)) | | |
| 20. | CAST('123.4' AS Decimal) | | |
| 21. | Arithmetic overflow error converting numeric to data type varchar. | | |