Explicitly converts an expression of one data type to another.
| Convert |
Copy Code
|
|---|---|
-- Converts the string 123 into an integer SELECT CONVERT( Int, '123') |
|
SQL Server Differences
VistaDB does not implement all the special rules and behavior exceptions of SQL Server. Since VistaDB is .Net based it relies on conversions in .Net to work.
0 Does not convert to a datetime in .Net.
For an example of how large and complex these rules are in SQL Server look at this MSDN CAST and CONVERT topic.
VistaDB does not support all of the same rules. These are in many cases behaviors specific to builds of SQL Server. If you are running into cast or convert errors try to think in terms of explicit declaration.
CAST and CONVERT provide similar functionality